IF statement

Answered

Follow

Antonio Sabatelli

• December 31, 2017 16:00

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

1

• 

  Charles Ikenberry

  • January 02, 2018 00:46

  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. 

  1

  Permalink
• 

  Antonio Sabatelli

  • January 02, 2018 10:23

  Thank you Charles!

   

  0

  Permalink

Please sign in to leave a comment.