Excel "If" Statement - What is the correct Syntax?
Posted by Dianne on December 08, 2001 9:48 PM
I used to be able to do this in Lotus, but cannot work out the syntax for the "IF" statement in excel. Can anyone please help? I need this solved by Monday Morning (i.e. 12 hours from now).
Testing value in A1
If value is less than 25 then return "0"
If value is greater than or equal to 25 but less than 50 then return "1"
If value is greater than or equal to 50, return "2".
Thanks you in anticipation.