LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default I need a formula for subtracting from a negative number

If you must?? then incorporate ABS into your formula

--
Don Guillett
SalesAid Software

"Pat" wrote in message
...
I am having problems getting a formula to work when I have a negative
number
in the first cell and I subtract the second cell (a positive). It adds the
number instead of subtracting them. It also happens when I have two
negative
numbers that I am trying to subtract.


 
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
subtracting a constant number to all cells in the same column gimianame Excel Discussion (Misc queries) 2 August 11th 05 07:59 PM
2003= negative number&2004= negative number How Do I Calculate gro Jason Excel Worksheet Functions 1 January 14th 05 05:24 PM
Subtracting Negative Numbers Carole O Excel Worksheet Functions 2 January 4th 05 06:31 PM
How do I replace a negative number at the end of a formula with a. dealn2 Excel Discussion (Misc queries) 5 December 23rd 04 07:47 PM
Subtracting based on number of miles Ms Chewie Excel Discussion (Misc queries) 3 December 21st 04 05:35 AM


All times are GMT +1. The time now is 10:52 AM.

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"