LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtract a positive from a negative wolfman Excel Worksheet Functions 7 May 7th 13 11:30 PM
Formula with negative amount Roxy Excel Discussion (Misc queries) 11 February 14th 08 08:27 PM
Formula for amount owing subtract amount paid Taperchart Excel Worksheet Functions 1 June 4th 06 05:51 PM
how do i subtract a negative number anndee Excel Worksheet Functions 2 June 11th 05 08:14 PM
How do you subtract negative numbers? Deb Excel Worksheet Functions 2 May 10th 05 02:12 AM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"