IF calculations

jpmiii · Jul 12, 2008

number in "A1", number in"A2". I want to calculate difference and put the
difference in "A3" except if "A2" is input as "0", I want to put "0" in "A3".
Thanks

Gord Dibben · Jul 12, 2008

=IF(A2=0,0,A2-A1)

Or maybe

=IF(A2=0,0,A1-A2)

Gord Dibben MS Excel MVP

jpmiii · Jul 14, 2008

Thanks for the assistance.
--
jpmiii

Gord Dibben said:
=IF(A2=0,0,A2-A1)

Or maybe

=IF(A2=0,0,A1-A2)

Gord Dibben MS Excel MVP