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