+ Reply to Thread
Results 1 to 4 of 4

Minimum Amount with Positive and Negative Numbers

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    2

    Minimum Amount with Positive and Negative Numbers

    Hello!
    I have a spreadsheet that I use on a daily basis to calculate advances and payments. One column (E5) calculates what type of transaction, payment populates as a positive number and advance populates as a negative number. We have another column (G5) that we only use if there are additional transactions to account for. Column F5 calculates the total amount of the advance or payment from E5 and G5. We do not want to run any transaction unless it is $1,000.00 or more, whether it be for a payment or advance. I can get it to account for the positive (payment) side of it, but I can't figure out the formula for the negative (advance) side. This is my current formula that works for the positive side of it: =IF(E5+G5>=1000,E5+G5,0)
    Any help is greatly appreciated, my brain is mush from too many google searches and failed formulas

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Minimum Amount with Positive and Negative Numbers

    Maybe like this?

    =IF(E5+G5=<-1000,E5+G5,0)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-02-2016
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    2

    Re: Minimum Amount with Positive and Negative Numbers

    Oh my goodness. That works!!! I have tried that so many times just in the wrong order. THANK YOU!!!!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Minimum Amount with Positive and Negative Numbers

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ 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] SUMIF positive and negative numbers - take double a negative number?
    By Zordrail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 08:34 AM
  2. offsetting amount (positive and negative)
    By giomckenzie12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2013, 03:16 AM
  3. offsetting amount (positive and negative)
    By giomckenzie12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2013, 06:18 AM
  4. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  5. adding positive and negative numbers all as positive
    By tomvh444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2009, 04:08 PM
  6. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  7. Change negative amount to positive.
    By George in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-29-2005, 01: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