DND
Stay Safe, Healthy and be Kind - Stop Hate
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.
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.
Last edited:
