ExcelBanter - simple formula with blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - simple formula with blank cells (https://www.excelbanter.com/excel-worksheet-functions/20137-simple-formula-blank-cells.html)

Brian

simple formula with blank cells

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.

Reid McTaggart

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",A1+B1)

-Reid

"Brian" wrote:

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.

All times are GMT +1. The time now is 12:43 PM.