excel = this cell if this cell is blank

How do I use an IF staement to make a cell = to another cell if a third cell is blank??

IE:  a1=b1 if c1 is blank
Curtis LongAsked:
Who is Participating?
rspahitzConnect With a Mentor Commented:
Yes...add an AND clause right after the IF portion:

=IF( AND(C1="", D1=""), B1, "")
This formula in A1:

=IF(C1="", B1, "other value")
Saqib Husain, SyedEngineerCommented:
Enter this formula in A1
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

In some cases, you need to also check for empty, which can be done this way:

=IF(LEN(C1)=0, B1, "other value")
Curtis LongAuthor Commented:
Nice!!  :-)

One other question:

If I now want to say a1 = b1 if c1 is blank AND D1 says sam

Can I do this without blowing my brain up??  :-)
Curtis LongAuthor Commented:
Wonderful!!  Thank you!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.