| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple cells with isblank formula
Please help.. I have four cells .. which may or may not be blank.. i need to
return an answer in a seperate cell. ex: if a4 is blank, give me a3, if a3 is blank, give me a2....and so forth - working backwards.. please help. f19 - 2 f28 - 3 f37 - 4 f46 - blank Currently Im using the following formula.. which returns a zero: =IF(ISBLANK(F46),F37,AND(IF(ISBLANK(F37),F28,AND(I F(ISBLANK(F28),F19,0))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if(and(isblank( formula help | Excel Worksheet Functions | |||
| IF(ISBLANK for multiple cells A1:N1 | Excel Worksheet Functions | |||
| Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
| ISBLANK Formula Help | Excel Discussion (Misc queries) | |||
| ISBLANK Formula Help Request | Excel Worksheet Functions | |||
Threaded Mode
