Home 
Search 
Today's Posts 
#1




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




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




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
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  
Text "comparison" operator for "contains" used in an "IF" Function  Excel Worksheet Functions  
Insert "" in text "1234567890" to have a output like this"1234567890"  Excel Discussion (Misc queries) 