If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
Formula to subtract a negative amount
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!! |
#3
|
|||
|
|||
Formula to subtract a negative amount
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(B30,B3-C3," ") Then in E3 Place this formula.Copy and Paste it all the way down to, in your example,E9. =IF(B30,D3+E2," ") Hope this Helps Stew "hrbsh97" wrote: 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 | |
Display Modes | |
|
|