SimHub Functions

[DND]

Post here if you need help, or can provide it, to write functions within SimHub.
I'll start.
Goal:
Leaderboard last lap time will change color based on previous and best lap. 'A' would be my personal lap time and is what the formula is based on.

I created a formula in Excel I know works, I just need help in how to make it work in ncalc for SimHub
=IFS(LAST LAP=PREVIOUS LAP,"Yellow",LAST LAP<BEST LAP,"Purple",LAST LAP>PREVIOUS LAP,"Red",LAST LAP<PREVIOUS LAP,"Green")

I have tried this:
if([CurrentLapTime]<[BestLapTime],PURPLE,if([CurrentLapTime]<[LastLapTime],Green,if([CurrentLapTime]>[LastLapTime],Red,Yellow)))

And this:
if([CurrentLapTime]<[BestLapTime],PURPLE,[CurrentLapTime]<[LastLapTime],Green,[CurrentLapTime]>[LastLapTime],Red,Yellow)

Not having much luck with either so some help is required, please.

 

[Mike55]

Hi. Did you ever solve this?