Formula that will skip blanks cells
 

I am using this formula =IF(Weekly!D700,Weekly!D70,IF(Weekly!
C700,Weekly!C70,IF(Weekly!B700,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?

Formula that will skip blanks cells
 

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

"japc90" wrote:

I am using this formula =IF(Weekly!D700,Weekly!D70,IF(Weekly!
C700,Weekly!C70,IF(Weekly!B700,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?

Formula that will skip blanks cells
 

On Apr 14, 6:04 pm, BoniM wrote:
=IF(Weekly!D70<"",Weekly!D70,IF(Weekly!C70<"",We ekly!C70,IF(Weekly!B70<"*",Weekly!B70,0)))



"japc90" wrote:
I am using this formula =IF(Weekly!D700,Weekly!D70,IF(Weekly!
C700,Weekly!C70,IF(Weekly!B700,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?- Hide quoted text -

- Show quoted text -

Thank you. Worked like a charm!