Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
subtract a positive from a negative | Excel Worksheet Functions | |||
Formula with negative amount | Excel Discussion (Misc queries) | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
how do i subtract a negative number | Excel Worksheet Functions | |||
How do you subtract negative numbers? | Excel Worksheet Functions |