IF calculations
Thanks for the assistance.
--
jpmiii
"Gord Dibben" wrote:
=IF(A2=0,0,A2-A1)
Or maybe
=IF(A2=0,0,A1-A2)
Gord Dibben MS Excel MVP
On Fri, 11 Jul 2008 16:46:06 -0700, jpmiii
wrote:
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
|