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.

--
__________________________________
HTH

Bob

"hrbsh97" wrote in message
...
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!!