| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NESTED IF FORMULA - IGNORE BLANK CELLS
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!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drag formula - ignore blank cells | Excel Discussion (Misc queries) | |||
| Nested IF that will ignore blank (empty) cells | New Users to Excel | |||
| Nested IF function to ignore cells with no data | New Users to Excel | |||
| how to make a formula ignore blank cells | Excel Worksheet Functions | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
