Function indicating a row have empty value on several columns

[Aline]

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

 

[Joerg Mochikun]

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)),"Cells empty","Cells not
empty")

Cheers,

Joerg Mochikun

 

[Fred]

Try

=IF(COUNTBLANK(C1:E1)=0,"No blanks",COUNTBLANK(C1:E1)&" Blank Cells")