If Condition

[Arup Dutta Chowdhury]

I have an excel file where there are two rows. If I put data in any of the row the result in the third column (Result ) will show as Filled if both the rows are empty result column will show as not filled.

 

[vletm]

Arup Dutta Chowdhury
for cell D2 =IF(AND(B2="",C2=""),"not filled","Filled") and copy down

 

[Arup Dutta Chowdhury]

Thanks