Remember Me?

#1
February 15th 07, 05:58 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 15
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

#2
February 15th 07, 06:04 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,101
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

#3
February 15th 07, 06:10 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,397
nested "If statement" using text

you may have to use the trim() function to get rid of non visable characters.

=IF(trim(M1)="M",12,IF(trim(M1)="SM",24,IF(trim(M1 )="W",24.2,IF(trim(M1)="BW",26.07,IF(trim(M1)="A", 1)))))

or shorter
=vlookup(trim(M1),{"M","SM","W","BW","A";12,24,24. 2,26.07,1},2,0)
"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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Worksheet Functions 8 January 4th 07 01:01 AM lajohn63 Excel Worksheet Functions 1 October 6th 06 10:56 AM BCB New Users to Excel 7 May 13th 06 10:02 PM Pawaso Excel Worksheet Functions 3 January 19th 06 07:42 PM Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM

All times are GMT +1. The time now is 06:29 AM.