casey, i don't do excel, but i would try nesting them
in microsoft access, it would be
iif(test='A','test is A',
iif(test='B','test is B',
iif(test='C','test is C',
iif(test='D','test is D',
'test is none of A, B, C, D'))))
rudy
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
