NESTED IF FORMULA - IGNORE BLANK CELLS

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

I have a spreadsheet that is updated throughout the month and a column that
presents a summary of data entered-to-date. Is there a nested IF formula
that will look at the last non-blank cell and display the value. For instance:

IF E1="" THEN, D1, BUT IF D1 IS "", THEN C1, etc.... I would need a formula
through E1.

I was able to start this on my own but it got too complicated.

Thanks!!!!
 
for row 14 where you are looking for the last number in the row

=INDEX(14:14,0,MATCH(9999,14:14))
 
for row 14 where you are looking for the last number in the row

=INDEX(14:14,0,MATCH(9999,14:14))
 
Think we're on the right track. So to be more specific.

A1=$1000
B1=$3000
C1=
D1=
E1=
F1=Display of last non-blank in row

Eventually, C1 through E1 will be filled in.

The formula you provided returned a #NUM when I entered it
 
Think we're on the right track. So to be more specific.

A1=$1000
B1=$3000
C1=
D1=
E1=
F1=Display of last non-blank in row

Eventually, C1 through E1 will be filled in.

The formula you provided returned a #NUM when I entered it
 
Oh gosh. Hate to be pain, but I will also need the formula to ignore zeros
and be specific to A1:E1 (not just 1:1)

Evan
 
Oh gosh. Hate to be pain, but I will also need the formula to ignore zeros
and be specific to A1:E1 (not just 1:1)

Evan
 
I figured it out. Thanks so much!!!

Evan said:
Oh gosh. Hate to be pain, but I will also need the formula to ignore zeros
and be specific to A1:E1 (not just 1:1)

Evan
Click to expand...
 
I figured it out. Thanks so much!!!

Evan said:
Oh gosh. Hate to be pain, but I will also need the formula to ignore zeros
and be specific to A1:E1 (not just 1:1)

Evan
Click to expand...
 
Back
Top