sle7en7 Posted November 14, 2014 Share 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 Link to comment
michaelk Posted November 15, 2014 Share 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 Link to comment
sle7en7 Posted November 16, 2014 Author Share Posted November 16, 2014 Great coding advice, i will try to remember it, Thanks Mike. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.