View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default nested "If statement" using text

The code works exactly as written.
If I enter the following letters in M1 I get
M 12
SM 24
W 24
BW 26.07

any other input get FALSE because M1="A",1 there is no 2nd parameter

you could write M1="A",1,0

then you would get a 0 for any other response

"RonB" wrote:

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