show class name as something else

[sle7en7 1]

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

[michaelk 585]

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

[sle7en7 1]

Great coding advice, i will try to remember it, Thanks Mike.