ExcelBanter - IF calculations

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - IF calculations (https://www.excelbanter.com/new-users-excel/194613-if-calculations.html)

jpmiii

IF calculations

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
--
jpmiii

Gord Dibben

IF calculations

=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

jpmiii

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

All times are GMT +1. The time now is 06:26 AM.