Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# excel = this cell if this cell is blank

Posted on 2015-02-02
Medium Priority
64 Views
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
0
Question by:HDM
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 2

LVL 22

Expert Comment

ID: 40584595
This formula in A1:

=IF(C1="", B1, "other value")
0

LVL 43

Expert Comment

ID: 40584599
Enter this formula in A1
=if(c1="",b1,"")
0

LVL 22

Expert Comment

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

=IF(LEN(C1)=0, B1, "other value")
0

Author Comment

ID: 40584640
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??  :-)
0

LVL 22

Accepted Solution

rspahitz earned 2000 total points
ID: 40584661
Yes...add an AND clause right after the IF portion:

=IF( AND(C1="", D1=""), B1, "")
0

Author Closing Comment

ID: 40584730
Wonderful!!  Thank you!!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will diâ€¦
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month8 days, 11 hours left to enroll