Help with a formula

[YOUNAN]

Hello,

I need help with a formula.
i need to show YES if Cells C1, D1 are empty, and NO if they are populated ( C1 & D1 would contain date .

Thanks in advance

 

[Joe4]

What if one is populated and the other isn't?

This would return "YES" if both were empty, otherwise return "NO" (if either of them has a value):

=IF(AND(C1="",D1=""),"YES","NO")

 

[YOUNAN]

Thank you very much for your fast respond.
even if one is populated it would return NO , when both are empty it would show YES.

Best regards.

 

[YOUNAN]

Thank you very much it works like a charm.

 

[Joe4]

You are welcome.

 

[YOUNAN]

Hello again,

I wonder if someone could help me again, I want the above formula to be edited to do the following. I needed to do some changes in my members excel file.
C2 containes member name, D2 is if the member left, E2 if the member died, so if the row contains name and C & D cells are empty it should show Yes in cell F which means he is active. and would show NO if ay of cells C, D are populated.
when C2 ( name ) is empty nothing should show in CELL F2 ( yes or no ).

Thanks in advance

 

[Joe4]

C2 containes member name, D2 is if the member left, E2 if the member died, so if the row contains name and C & D cells are empty it should show Yes in cell F

I assume meant if row contains name and D and E are empty.

Try:

=IF(C2="","",IF(AND(D2="",E2=""),"Yes","No"))