nested "If statement" using text
This is my expression.
=IF(M1="M",12,IF(M1="SM",24,IF(M1="W",24.2,IF(M1=" BW",26.07,IF(M1="A",1)))))
The result is "False" for the "M","A", and "w". The results for "SM" and
"BW" are correct. (24 and 26.07) is there something wrong with my statement?
Thanks
Ron B
|