Hello,
I have encountered a problem in which there is an IF statement like that :
if (statement < 1,1,0)...
what do the 3 numbers represent?
Thanks
Hello,
I have encountered a problem in which there is an IF statement like that :
if (statement < 1,1,0)...
what do the 3 numbers represent?
Thanks
Antonio,
The first number is the condition against which the statement is evaluated (<1).
The second number is the resulting value if statement is less than 1.
The third number is the resulting value if the statement is not less than 1.
Hope that is what you were looking for. You can easily test/use simple IF statements in Excel to make sure you understand how they work.
Please sign in to leave a comment.
Comments
2 comments