Excel "IF" formula

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

I'm trying to make a formula which will recognize if the cell above is empty
to use the cell above that one, then the cell above the second one, etc., and
finally if all cells have values in them to take the first one above the one
your working in. I've come up with the following formula and it works fine if
the G35 is emtpy, it finds G34. But if both G35 & G34 are empty it doesn't
find G33. Can anyone help me?
=IF(G35="",G34,IF(G34="",G33,IF(G33="",G32,G35)))
 
You have posted to a newsgroup designed for quaestions about the database
program - Microsoft Access. You will likely get a better response if you
repost your question to newsgroup dedicated to questions about Microsoft
Excel.
 
Hi Diane, Yes you have posted to the wrong news group, but having said that,
your if statement fails because the first two ifs both evaluate to true, once
that is achieved, the third if is not evaluated at all.

I will post a solution if I find one.

Kindest Regards

Mike B
 
iletisinde şunu yazdı said:
I'm trying to make a formula which will recognize if the cell above is
empty
to use the cell above that one, then the cell above the second one, etc.,
and
finally if all cells have values in them to take the first one above the
one
your working in. I've come up with the following formula and it works fine
if
the G35 is emtpy, it finds G34. But if both G35 & G34 are empty it doesn't
find G33. Can anyone help me?
=IF(G35="",G34,IF(G34="",G33,IF(G33="",G32,G35)))
Click to expand...

=IF(G8="";0;1)
write above formula sutun H

=IF(H8=1;G8;I7)
write above formula sutun I

then you can see that you want in the sutun I
 
Back
Top