+ Reply to Thread
Results 1 to 3 of 3

Need a formula that subtracts or adds a a specific value

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Need a formula that subtracts or adds a a specific value

    I have a workbook where that deals with weights. I need a formula that will subtract the extra weight taken from it. for instance if i move 5050 lbs and the goal was 5000 then i just want to subtract the 50 extra pounds. also i want to be able to add weight tot the next cell if i don't achieve the goal of 5000.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,725

    Re: Need a formula that subtracts or adds a a specific value

    That doesn't make much sense to me. Can you re-phrase it and/or attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Pete

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need a formula that subtracts or adds a a specific value

    Maybe something this

    =IF(A1>5000,A1-5000,A1)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I want to create a conditional formula that adds a specific value...
    By mbxs3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2012, 08:13 PM
  2. [SOLVED] Sum adds rather than subtracts negative numbers?
    By innatedoc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-23-2012, 01:31 AM
  3. Replies: 3
    Last Post: 01-26-2012, 01:38 PM
  4. creating a button that adds/subtracts
    By gbWildy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-26-2007, 01:10 PM
  5. Replies: 0
    Last Post: 10-04-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1