Is there any way you could use a lookup formula instead?
Provide some more info on what you are doing.
You can also use this technique

=IF(A1=1,"a","")&IF(A1=4."b","")&IF and so on

I wouldn't recommend it and definitely not if you can do it with a
lookup formula

Regards,

Peo Sjoblom


HELPME wrote:
Is there a way around the excel rule that you may only have 7 functions in
one formula, im trying to do an if statemet with like 15 IFs.....can this be
done