Hello All,
I am trying to test a range of values in a cell:
if(and("a1" is 0 to 10, "Jack"), if("a1" is 10001 to 11000, "Jim),
if("a1" is 11000 to 12000, "Joe')
Can anyone give me the correct systax or any other way to test this?
Thank you
Syed
--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread:
http://www.excelforum.com/showthread...hreadid=475212