RLCSGT
Apr 4, 2011, 11:43 AM
Hi, I know this will probably be easy to most of you? But I need to have a formula so that I can show amount of hours allocated to a task in collumn A amount used in Collumn B and the totals in Collumn C However I want it to work whether the Collumn A is greater or lower than collumn B and show this with either a + or - sign.
So for example:

Collumn A hours Allocated = 580
Collumn B hours Used = 540
Collumn C = -40

Or

Collumn A Hours allocated = 580
Collumn B Hours Used = 620
Collumn C = +40

And so on!

All help greatly appreciated.

Emland
Apr 4, 2011, 01:58 PM
=sum(a?-b?)

The ? Indicated the cell number. You would need to format your cells to display the positive and negative as you like.

I used Open Office spreadsheet which is a free version very similar to Excel. It gives the minus (-) sign on negative automatically but does not give the plus (+) sign.

Hope that helps.

JBeaucaire
Apr 4, 2011, 02:52 PM

Use the formula shown, then apply a custom number format to that cell of +0;-0.

In C1, then copied downward:

=B1-A1