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
|