Link to home
Create AccountLog in
Avatar of Conernesto
ConernestoFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of gnazareth
gnazareth
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account