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