Formula to subtract a negative amount

H

hrbsh97

I have a problem with my spreadsheet as I can't get it to subtract a number
that is in the negative .. can someone please direct me as to what I am doing
wrong? :) .. thanks!

Week Ending Hours Worked Hours Paid Balance Carry Over

9/12/2008 40.00 38.25 1.75 1.75
9/19/2008 43.25 30.00 13.25 15.00
9/26/2008 50.25 30.00 20.25 35.25
10/3/2008 48.25 30.00 18.25 53.50
10/10/2008 47.00 30.00 17.00 70.50
10/17/2008 46.45 30.00 16.45 86.95
10/24/2008 18.45 30.00 (11.55) 98.50
What formula do I use to get it to subtract a negative number? .. also, do I
have to put a formula in every cell or is there put formulas in multiple
cells at one time?

Thanks in advance to all your experts!! .. I'm learning!!
 
B

Bob Phillips

Surely, you would just add as normal, when you ad a negative number it is
effectively subtracted.

You can enter formulas in batch by selecting the target cells, enter the
formula as it applies to the first of these in the formula bar, then press
Ctrl-Enter rather than just Enter.
 
S

stew

I am Not Sure I understand However , as I am learning as well. However try this

Assuming Tittle" Week End" Is in A1
Assuming Tittle "Hours Worked is in B1 Etc
And the first date is in A3

Then in D3 place this formula. Copy and Paste it all the way down to,
in,your example,D9.
=IF(B3>0,B3-C3," ")
Then in E3 Place this formula.Copy and Paste it all the way down to, in your
example,E9.
=IF(B3>0,D3+E2," ")

Hope this Helps

Stew
 
Top