Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Excel formula based on a Null Value

Posted on 2013-05-22
Medium Priority
263 Views
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
0
Question by:Conernesto
1 Comment

LVL 3

Accepted Solution

gnazareth earned 2000 total points
ID: 39189049
=IF(ISBLANK(A1),B1,0)
0

## Featured Post

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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 on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
###### Suggested Courses
Course of the Month14 days, 13 hours left to enroll