IF statements

[donmiller]

I need 7 IF statements in one cell, how do I do this? Excel doesn't
allow me to have this many. Do I have to link 2 cells?? What do I
do?!?!?!

 

[Kevin Stecyk]

Don,

What is your intended equation?

Once we see it, we might be able to suggest a better solution.

Regards,
Kevin

 

[Harlan Grove]

I need 7 IF statements in one cell, how do I do this? Excel doesn't
allow me to have this many. Do I have to link 2 cells?? What do I
do?!?!?!

There are workarounds, but they differ depending on what, exactly, you're trying
to do and whether there's any easily exploited pattern to your IF conditionals.
Post your formula, and others will work with it. Otherwise, there's too much
guesswork involved.

Without your formula, your problem is not unlike 'my car doesn't run'. The best
answer to that depends on whether it's out of gas, the engine or transmission is
broken, or it's overturned in a ditch. More information from you gets you more
help more quickly.

 

[Jason Morin]

Typically a requirement of more than 7 IF statements means
you need a large lookup table that returns a value based
on a certain condition being met (IF-THEN).

If you post some data (don't attach a file) and give an
example of what you're trying to do, someone can provide
you with a VLOOKUP formula or similar type solution.

HTH
Jason
Atlanta, GA