| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formula and skip blanks | Excel Discussion (Misc queries) | |||
| skip blanks | Excel Worksheet Functions | |||
| Skip Over Blanks | Excel Discussion (Misc queries) | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
| Skip multiple blanks | Excel Discussion (Misc queries) | |||
Linear Mode
