7 Function rule

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

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

Why don't you post the details for comments.

--
Don Guillett
SalesAid Software

"HELPME" wrote in message
...
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

Can you get around the limit of nesting more than 7 deep... Yes... But in my
experience there is rarely any need to do something like that. As is stated
using a Vlookup or some other method will normally do what you need done. If
you would like to see how to get around the rule of 7 check out this link...

http://www.cpearson.com/excel/nested.htm
--
HTH...

Jim Thomlinson


"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

On Thu, 28 Dec 2006 14:27:01 -0800, 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

Not in versions prior to XL2007.

There's most likely another solution that is also simpler, than trying to nest
15 IF statements. If you post some details of what you are trying to
accomplish, someone will help.
--ron