nesting formulas

[Guest]

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.

 

[Frank Kabel]

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

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.

 

[Peo Sjoblom]

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

=IF(B1<0,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(B1>0,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

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.

 

[Guest]

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(AB4>1.25,$S$807,IF(AB4>0.76,$S$808,IF(AB4>0.26,$S$809,IF(AB4=0,$S$810))))

----- Peo Sjoblom wrote: ----

Post your formula, sounds like you could use a lookup tabl
and an if statemen

=IF(B1<0,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,"u
",0))))),IF(B1>0,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 easie

--

Regards

Peo Sjoblo

Looking for help on nesting. I have a spreadsheet that i have nested 5 i

statements that works very well. it simply looked at one cell and applie
the =if statement. Now i need it to look at another cell first to determin
which of 3 different =if statements to use on the original cell
anythoughts? Thanks

 

[Guest]

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(AB4>1.25,$S$807,IF(AB4>0.76,$S$808,IF(AB4>0.26,$S$809,IF(AB4=0,$S$810))))

 

[Frank Kabel]

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

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(AB4>1.25,$S$807,IF(AB4>0.76,$S$808,IF(AB4>0.26,$S$809,IF(
AB4=0,$S$810)))))