Multiple if statements in one formula??

  • Thread starter Thread starter rglasunow
  • Start date Start date
R

rglasunow

I am currently trying to write a formula using an if formula. However
some of the calculations the formula returns will be 0 or #REF becaus
some of the data is not filled until yet on a cell the formula i
calling. Is there a way to write into the formula that if th
calculation comes out 0 or #REF that it will jump and reference
different cell? So I guess that would be two if formulas in on
formula.

I hope that makes sense.

Thank you in advance!
 
very possible, and *can do* as Ivan Moala says. drawback being you ca
only nest 7 if statements in one cell function. maybe you should loo
at another function? without seeing your data, or a detaile
explanation, it's hard to say.

example:
=if(a1="",if(b1="",if(c1="",if(d1="",if(e1="","",e1)d1)c1)b1)a1)

this will look straight across from a1 to e1 and pull the first cel
which has a value. if small, like this, adapt for specifics.

hope this helps.

Regards,

Zack B
 
Let me try to be a bit more specific. I want to write an "if" command.
However, since the cells are bases off a calendar year there are stil
quite a few this year that contain nothing in the cells. So I woul
like to run the if command. But for the cells that are blank which ar
included in the formula I would like the if command to pull informatio
from another cell. So do the if command and if a cell is blank then d
a different if command pulling information from another cell. I hop
that makes for sense to my question.

Thanks again
 
well, why don't we start with the formula your working on now..
where your data is housed..
&
what the expected outcome should be.

are you always going to want to use the last cell which is greater tha
zero in a range? name the terms of the formula also
 
Back
Top