IF Statement useage
I have the folowing IF statment that works well.
in "P11"
=IF(M11=90,10,IF(M11=100,20,IF(M11=110,30,IF(M11=1 20,40,IF(M11=130,50,IF(M11=140,60,IF(M11=150,70,IF (M11159,80,))))))))
The value in P11 can be from 10 to 80 based on that statment. I have tried
to add in the front of the IF statment "IF(M11=0,0," making it like this
=IF(M11=0,0,IF(M11=90,10,IF(M11=100,20,IF(M11=110, 30,IF(M11=120,40,IF(M11=130,50,IF(M11=140,60,IF(M1 1=150,70,IF(M11159,80,)))))))))
and it always fails with an error. What am I doing wrong?
|