I am unable to use the IF function in a user variable. No matter what I put in I get an equation error. Even IF(1, 1, 2).
I'm using version 7.3.5 of the analysis tool. A bunch of functions listed in the help screen aren't listed in the edit equation screen. But all of the unlisted functions work except for the IF.
Thanks,
Paul
Unable to use IF function
-
- Posts: 220
- Joined: Thu Mar 15, 2007 3:41 pm
- Location: Norwich, UK
- Contact:
IF(1,2,3) can't work...
The first part is the check - see if a state exists. Typically this is something like if(var_x>40,...). As you'll notice 1 isn't a check, so it doesn't know if the answer is true or false.
The second part is the result if true.
The third part is the result if false.
So, to give an output of 1 when, say, brake pressure is above 40 units, but 0 if it isn't, and assuming brake pressure is variable 003:
IF(var_003>40,1,0)
It's exactly like the Excel function, so reading MS's help file might give some extra pointers.
The first part is the check - see if a state exists. Typically this is something like if(var_x>40,...). As you'll notice 1 isn't a check, so it doesn't know if the answer is true or false.
The second part is the result if true.
The third part is the result if false.
So, to give an output of 1 when, say, brake pressure is above 40 units, but 0 if it isn't, and assuming brake pressure is variable 003:
IF(var_003>40,1,0)
It's exactly like the Excel function, so reading MS's help file might give some extra pointers.
Monoposto 2000 - Reynard 883 Toyota
-
- Posts: 220
- Joined: Thu Mar 15, 2007 3:41 pm
- Location: Norwich, UK
- Contact:
Went racing at the weekend. Just before I left I updated to the latest version of Analysis (uninstall using RTs start menu link, then configured paths and settings as per normal).
Did my sessions. Went to check stuff on the laptop, and was told that my IF functions were invalid, and that the equation for Water Temp (Bosch sensor, standard variable) was also wrong.
That's pretty crap to be honest... I gave up looking at datalogging after that, as I was fed up with problems... But at least our oil pressure sensor hasn't (that I'm aware of) started leaking again. But it was wet, so it's probably filled with water because RT can't be bothered to reasonably seal a product sold specifically for use in racing cars...
I'm not happy. At least I didn't waste money on a Dash3 - I need that cash to keep the DL1 in working condition.
Did my sessions. Went to check stuff on the laptop, and was told that my IF functions were invalid, and that the equation for Water Temp (Bosch sensor, standard variable) was also wrong.
That's pretty crap to be honest... I gave up looking at datalogging after that, as I was fed up with problems... But at least our oil pressure sensor hasn't (that I'm aware of) started leaking again. But it was wet, so it's probably filled with water because RT can't be bothered to reasonably seal a product sold specifically for use in racing cars...
I'm not happy. At least I didn't waste money on a Dash3 - I need that cash to keep the DL1 in working condition.
Monoposto 2000 - Reynard 883 Toyota
Return to “General software support”
Who is online
Users browsing this forum: No registered users and 3 guests