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

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

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