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

 

[njimack]

Welcome to the Board!

Something like this...
=IF(A1*B1,A1-B1,0)

 

[Turner93]

Neil,

You are my new best friend. Thanks so much.

 

[Ellpee]

This is driving my crazy!

I want to subtract A1 from B1 only if there is a value displayed in both cells (note there is a formula in both cells). If there is not a value displayed in both A1 and B1 then I want the display in C1 to be blank. I keep getting a display of 0 in C1 and its messing up my average.

I've tried sumif with isblank but i think isblank doesn't work in this case because although the display looks blank there is a formula in both.

HELP ME! Thanks!

 

[Rick Rothstein]

This is driving my crazy!

I want to subtract A1 from B1 only if there is a value displayed in both cells (note there is a formula in both cells). If there is not a value displayed in both A1 and B1 then I want the display in C1 to be blank. I keep getting a display of 0 in C1 and its messing up my average.

I've tried sumif with isblank but i think isblank doesn't work in this case because although the display looks blank there is a formula in both.

Maybe this...

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

 

[Jonmo1]

Perhaps

=IF(COUNT(A1,B1)=2,B1-A1,"")

 

[rossa]

I got this to work, it assumes your formula in the cells in columns A & B return a blank.

IF(AND(A1<>"",B1<>""),A1-B1,"")

 

[stefankemp]

I think you mean you want to subtract B1 from A1

I think the function you are looking for is COUNTBLANK.

 

[Ellpee]

Thank you so much! This worked perfectly!

 

[Ellpee]

Rick Rothstein!

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

Thank you! This worked perfectly!