Not Enough If's????

  • Thread starter Thread starter tallpaul
  • Start date Start date
T

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
 
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.
 
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
 
Ideally I would like a nested "if" function formula to accept 15
options. I am limited to 7, how do I overcome this??
Please advise as I am pulling my hair out.
Cheers, TallPaul
Click to expand...

Use a different function.

Usually VLOOKUP turns out to be what would work best. It's frequently easier
to follow and/or change the logic, too.


--ron
 
Back
Top