nesting formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 said:
Looking for help on nesting. I have a spreadsheet that i have nested
Click to expand...
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(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


rmichael said:
Looking for help on nesting. I have a spreadsheet that i have nested 5 if
Click to expand...
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(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


rmichael said:
Looking for help on nesting. I have a spreadsheet that i have nested 5 i
Click to expand...
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
 
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))))
 
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.
Click to expand...
=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)))))
 
Back
Top