| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then Calculations | Excel Worksheet Functions | |||
| age calculations | Excel Discussion (Misc queries) | |||
| IRR calculations | Excel Discussion (Misc queries) | |||
| Calculations | Setting up and Configuration of Excel | |||
| #N/A in calculations | Excel Worksheet Functions | |||
Hybrid Mode
