| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if(and(isblank( formula help
I have columns data
ie: ad ae ag ah 12 23 34.00 0 result should be "" "" "" "" 12 blank blank blank result should be "" 1 1 1 blank 23 blank blank result should be 1 " " 1 1 25 blank blank 12 blank blank blank blank result should be " " "" "" "" i have formula to validate each column and it is supposed to return a 1 if any of the cells are blank???? =IF(AND(ISBLANK(Data!$AD4),ISBLANK(Data!$AE4),ISBL ANK(Data!$AG4),ISBLANK(Data!$AH4)),1,"") but it doesn't work for all cases |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning "no value" | Excel Worksheet Functions | |||
| Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell | Excel Worksheet Functions | |||
| isblank | Excel Worksheet Functions | |||
| ISBLANK Formula Help | Excel Discussion (Misc queries) | |||
| ISBLANK Formula Help Request | Excel Worksheet Functions | |||
Threaded Mode
