Subtract cells but only if both have values

[Turner93]

I am writing a workbook and need to subtract one cell from another but only if both cells have values entered. I'm sure this is simple but I can't figure it out. Thanks in advance for your help.


John

 

[Ellpee]

Maybe this...

=IF(A1*B1,A1-B1,"")

Ok there is one problem I'm running into. This formula is also turning actual 0 difference as a blank.

let's say
A1=2% - B1=2% then I want C1=0% … C1 is displaying a blank when it should be 0%

I only want C1 to be blank if both A1 and B1 display as blank.

Currently there are some numbers and some blanks in column A and Column B…I would like column C to calculate the difference between A and B only if A and B both contain values.

The formula is kind of working but if the difference is 0% I need that to display.

I'm soooooooo close but so far! Help!

 

[stefankemp]

Try this:

=IF(COUNTBLANK(A1:B1)>0,"",A1-B1)