SimHub Functions

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.
1618681233963.png
 
Last edited:

Latest News

Online or Offline racing?

  • 100% online racing

    Votes: 105 7.8%
  • 75% online 25% offline

    Votes: 139 10.4%
  • 50% online 50% offline

    Votes: 193 14.4%
  • 25% online 75% offline

    Votes: 379 28.3%
  • 100% offline racing

    Votes: 517 38.6%
  • Something else, explain in comment

    Votes: 5 0.4%
Back
Top