Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function indicating a row have empty value on several columns
I am trying to get an IF formula that will show rows that have empty cells. A
formula on column F that indicates a row that have empty values on column C, D and E. column A column B column C column D column E column F 1 G C E E 2 G False row 3 D R R R 4 E False row 5 O False row 6 T R R G Any suggestion? Thanks -- Aline |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function indicating a row have empty value on several columns
Returns TRUE, if cells D to E are empty::
=AND(ISBLANK(C1),ISBLANK(D1),ISBLANK(E1)) If it must be an IF statement: =IF(AND(ISBLANK(C1),ISBLANK(D1),ISBLANK(E1)),"Cell s empty","Cells not empty") Cheers, Joerg Mochikun "Aline" wrote in message ... I am trying to get an IF formula that will show rows that have empty cells. A formula on column F that indicates a row that have empty values on column C, D and E. column A column B column C column D column E column F 1 G C E E 2 G False row 3 D R R R 4 E False row 5 O False row 6 T R R G Any suggestion? Thanks -- Aline |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function indicating a row have empty value on several columns
Try
=IF(COUNTBLANK(C1:E1)=0,"No blanks",COUNTBLANK(C1:E1)&" Blank Cells") "Aline" wrote in message ... I am trying to get an IF formula that will show rows that have empty cells. A formula on column F that indicates a row that have empty values on column C, D and E. column A column B column C column D column E column F 1 G C E E 2 G False row 3 D R R R 4 E False row 5 O False row 6 T R R G Any suggestion? Thanks -- Aline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to return non empty cells over several columns | Excel Discussion (Misc queries) | |||
Delete rows that are empty across columns | Excel Worksheet Functions | |||
Empty Rows and Columns | New Users to Excel | |||
I need a little help with comparing columns and indicating the mat | Excel Worksheet Functions | |||
empty columns | Excel Worksheet Functions |