Yes you can get around the 7 nested if's. One way is the CONCATENATE
function which gives you about 30 comparisons an example:

=CONCATENATE(IF(A1="A",1,""), IF(A1="B",2,""), IF(A1="C",3,"")

Another way is using the concatenation operator (&) for example:

=IF(A1="A",1,"") &IF(A1="B",2,"") &IF)A1="C",3,"")

Using the (&) operator will not limit you to 30 comparisons. For all
practical purposes it's unlimited.


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=557599