I am attempting to write an If statement as follows, but it only returns "FALSE". Can anyone help with what I am doing incorrectly?
=IF(L4="0","Future",IF([@Status6]="-1","Current"))
Thank you in advance for your help!
I am attempting to write an If statement as follows, but it only returns "FALSE". Can anyone help with what I am doing incorrectly?
=IF(L4="0","Future",IF([@Status6]="-1","Current"))
Thank you in advance for your help!
Try using the evaluate function button on the formula toolbar to step through how the function is evaluating.
It might be something to do with the double quotes around the numbers. If they are not text then the double quotes should be unnecessary.
you're missing the if value is false parameter in the second IF.
e.g. =IF(L4="0","Future",IF([@Status6]="-1","Current","ERROR"))
Where I've put "ERROR" you need to replace it with whatever satisfies the FALSE, FALSE outcome of both IF statements.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks