Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hi Guys,
I am trying to write an if statement based on the results in cell A1 and i cant seem to get this correct
the rules i want to apply in the statement are
If A1 > 0.49 then A1=100
If A1 > 0.39 and less then 0.50 then A1=75
If A1 >0.29 and less then 0.40 then A1= 50
how can i write this in one If statement
thank you guys
I am trying to write an if statement based on the results in cell A1 and i cant seem to get this correct
the rules i want to apply in the statement are
If A1 > 0.49 then A1=100
If A1 > 0.39 and less then 0.50 then A1=75
If A1 >0.29 and less then 0.40 then A1= 50
how can i write this in one If statement
thank you guys