Not Enough If's????

[tallpaul]

Ideally I would like a nested "if" function formula to accept 1
options. I am limited to 7, how do I overcome this??
Please advise as I am pulling my hair out.
Cheers, TallPau

 

[Dave R.]

I would suggest overcoming this by writing back with some sample data (not a
file), and what you're trying to do. Or, your 15-long IF statements, and
some sample data (pasted into the message, not an XL file). This way people
can look at it to figure another way out.

 

[Vasant Nanavati]

If you post the details, I'm sure a better way can be found.

 

[Frank Kabel]

Hi
normaly you could use a lookup range with your conditions and values
and use the function VLOOKUP. But you may provide some more details