Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAES
I want to calculate two cells and have the answer showing a negative or
positive answer in another cell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAES
Bennyboy,
Please provide more information: --What are the cells? --What is the data in the cells? --What is the calculation to be performed? --What cell do you want this calculation in? Cell A1: 2 Cell A2: 4 Cell A3: =A2+A1 (Cell A3 will show 6) Cell A4: =A2-A1 (Cell A4 will show 2) Cell A5: =A1-A2 (Cell A5 will show -2) HTH, Conan "Bennyboy" wrote in message ... I want to calculate two cells and have the answer showing a negative or positive answer in another cell |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAES
Two cells to calculate are A1 and A2
In A3 enter =A1+A2 If the answer to A3 is negative it will show negative, if positive it will show positive. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 16:20:00 -0800, Bennyboy wrote: I want to calculate two cells and have the answer showing a negative or positive answer in another cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formulaes | Excel Discussion (Misc queries) | |||
Files and formulaes | Excel Worksheet Functions | |||
Help with Macros or formulaes | Excel Discussion (Misc queries) | |||
Help with Macros or formulaes | Excel Discussion (Misc queries) | |||
copy formulaes w/o filename | Excel Discussion (Misc queries) |