if no value equal 0 if change equals change amount

[agoodson1956]

I have a cell A2 with a number in it. Then I have another cell D2 with a number in it.

I want to subtract A2 from D2 and update cell G2, but if the value in D2 is blank I want G2 value to be 0

Help please

 

[SQUIDD]

try this in g2

=IF(D2="","0",D2-A2)

dave

 

[Canapone]

Hi,

in G2

--IF(D2,D2-A2)

Regards

----------

Hi Squidd, sorry: did not mean to overlap.

 

[Tetra201]

Just to note:

SQUIDD's formula will return "0" as text, not as a number.
Canapone's formula will not work if cell D2 is blank-looking (not actually empty).

The following formula addresses both issues:

=IF(D2="",,D2-A2)

 

[SQUIDD]

Hi

if value 0 is required you may also change my formula to

=IF(D2="",0,D2-A2)

dave

 

[agoodson1956]

Thank you that did the trick!

 

[Tetra201]

You are welcome.