Formula that will skip blanks cells

J

japc90

I am using this formula =IF(Weekly!D70>0,Weekly!D70,IF(Weekly!
C70>0,Weekly!C70,IF(Weekly!B70>0,Weekly!B70,0))) so that a summary
spreadsheet will update with the most recent column of data.

The issue I am having is that occassionally cells will be zero and I
need that data pulled into the summary spreadsheet. With this formula
though it looks at the zero and then goes to the next cell. How can I
make it pull in the zero.

All of the cells not filled in will be blank. Is there a formula that
would do the same thing but skip blank cells instead of looking for
cells with values greater than 0?
 
G

Guest

=IF(Weekly!D70<>"",Weekly!D70,IF(Weekly!C70<>"",Weekly!C70,IF(Weekly!B70<>"",Weekly!B70,0)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding cells by 2 criteria that move. 1
Ignore Blanks 2
need help with formula 7
Salary by Qtr Formula 1
Excel 2003 - Skip a cell 5
Need help with a formula 3
How do I display 0 if it is the end result for a formula 4
Blanks or zeros in formulas 3

Top