View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hrbsh97 hrbsh97 is offline
external usenet poster
 
Posts: 8
Default Formula to subtract a negative amount

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!!