| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Nested "IF" Statement | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
