nesting formulas

Looking for help on nesting. I have a spreadsheet that i have nested 5 if statements that works very well. it simply looked at one cell and applied the =if statement. Now i need it to look at another cell first to determine which of 3 different =if statements to use on the original cell. anythoughts? Thanks.

Hi
can you post your complete conditions (with an example as plain text).
then it should be quite easy to adapt your existing formula (post this
as well)

You may consider using VLOOKUP or CHOOSE dependening on your conditions
and expected results

--
Regards
Frank Kabel
Frankfurt, Germany

"rmichael" schrieb im Newsbeitrag
...
Looking for help on nesting. I have a spreadsheet that i have nested
5 if statements that works very well. it simply looked at one cell and
applied the =if statement. Now i need it to look at another cell first
to determine which of 3 different =if statements to use on the original
cell. anythoughts? Thanks.

Post your formula, sounds like you could use a lookup table
and an if statement

=IF(B10,IF(A1=1,"au",IF(A1=2,"eu",IF(A1=3,"cu",IF (A1=4,"du",IF(A1=5,"tu",0)
)))),IF(B1=0,IF(A1=1,"ua",IF(A1=2,"ub",IF(A1=3,"uc ",IF(A1=4,"ud",IF(A1=5,"ue
",0))))),IF(B10,IF(A1=1,"z",IF(A1=2,"y",IF(A1=3," s",IF(A1=4,"r",IF(A1=5,"w"
,0))))))))

is an ugly example but a lookup table might be easier

--

Regards,

Peo Sjoblom


"rmichael" wrote in message
...
Looking for help on nesting. I have a spreadsheet that i have nested 5 if
statements that works very well. it simply looked at one cell and applied
the =if statement. Now i need it to look at another cell first to determine
which of 3 different =if statements to use on the original cell.
anythoughts? Thanks.

This is current working formula that goes to 1 table. now I need to look at a second cell to determine which of three tables or set of formulas to use to apply to the original cell data.

=IF(W4=0,0,IF(AB41.25,$S$807,IF(AB40.76,$S$808,I F(AB40.26,$S$809,IF(AB4=0,$S$810)))))

Hi
can you also post the conditions for determining the sheet which is to
be selected. Maybe a combination of INDIRECT and your formula will do

--
Regards
Frank Kabel
Frankfurt, Germany


rmichael wrote:
This is current working formula that goes to 1 table. now I need to
look at a second cell to determine which of three tables or set of
formulas to use to apply to the original cell data.


=IF(W4=0,0,IF(AB41.25,$S$807,IF(AB40.76,$S$808,I F(AB40.26,$S$809,IF(
AB4=0,$S$810)))))