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)))

This assumes that you are looking for numbers:

=LOOKUP(99^99,G1:G35) will return the contents of G35 if it is not blank.
Otherwise it will return the first non-blank number above G35
--
Gary''s Student - gsnu200822


"Diane" wrote:

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)))

I've never worked with LOOKUP, thanks!!
--
Diane


"Gary''s Student" wrote:

This assumes that you are looking for numbers:

=LOOKUP(99^99,G1:G35) will return the contents of G35 if it is not blank.
Otherwise it will return the first non-blank number above G35
--
Gary''s Student - gsnu200822


"Diane" wrote:

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)))