Using IF for blank cells

[Yusuf]

Hi all

I'm trying to write a formula that would return "not complete" if both cells I'm looking at are blank

Eg;
A1 = ""
B1 = ""
A2 = 1
B2 = 4
A3 = 6
B3 = ""

In Col C I would like the formula telling me that only A1 and B1 is "not complete"

 

[S.H.A.D.O.]

Hi Yusuf,

Try this ...
=IF(A1="",IF(B1="","Not Complete",""),"")
... and Copy Down as Needed.

Hope this Helps.
All the Best.
SHADO

 

[fairwinds]

Hi,

Try:

=IF(A1&B1="","not complete","XXX")

 

[Yusuf]

PERFECT!!
Thanks guys
Yusuf