sle7en7 1 Posted November 14, 2014 (edited) what am I doing wrong here? =IF((C='ELEVATION-GLASS-30dB'), '30dB', IF((C='ELEVATION-GLASS-35dB'), '35dB', IF((C='ELEVATION-GLASS-37dB'), '37dB', IF((C='ELEVATION-GLASS-40dB'), '40dB', '')))) I'm trying to set the class name as the last string of the whole thing but I keep getting only 40dB and -1 for all the other classes. What to do? Edited November 14, 2014 by sle7en7 Quote Share this post Link to post
michaelk 472 Posted November 15, 2014 With if/then statements in worksheets: When in doubt, add more parentheses! =IF((C='ELEVATION-GLASS-30dB'), ('30dB'), (IF((C='ELEVATION-GLASS-35dB'), ('35dB'), (IF((C='ELEVATION-GLASS-37dB'), ('37dB'), (IF((C='ELEVATION-GLASS-40dB'), ('40dB'), 'MISC'))))))) hth mk Quote Share this post Link to post
sle7en7 1 Posted November 16, 2014 Great coding advice, i will try to remember it, Thanks Mike. Quote Share this post Link to post