simple formula with blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have values in cells a1 and b1 however a1 or b1 can be blank. The formula
in c1 should add the values of a1 and b1 only if there is a value in a1 and
b1 otherwise if a1 or b1 are blank the value of c1 should remain blank. I
appreciate help with a formula in c1.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
Excel functions 0
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Merging cells and formats 8
Excel formula / IF function 5
Nameing a function 1
Adding Cells, Get Error. 2
SUMIF with criteria "<>" & "=" 4

Back
Top