Excel formula based on a Null Value

I need a formulas that will pick up a cell value if a cell is blank. Below is example

Cell A1 is Blank Cell B1 has a value of 5 in Cell C3 I want a formula that will add B1 if A1 is blank. So if cell A1 is blank, I would get the value of 5 in C3. If A1 is equal to 1, I would get a zero or false in C3.

conernesto
ConernestoAsked:
Who is Participating?
 
gnazarethConnect With a Mentor Commented:
=IF(ISBLANK(A1),B1,0)
0
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.