+ Reply to Thread
Results 1 to 5 of 5

How to subtract & add in IF, THEN, OR Statements

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    Seattle
    MS-Off Ver
    Excel -MS Office 365 Subscription
    Posts
    48

    How to subtract & add in IF, THEN, OR Statements

    I have a basic problem and am looking for hopefully a simple answer. I am entering a dollar amount into one cell. I want the adjacent cell to either deduct $5 if the amount is less than $30 or deduct $10 if the amount is greater than $30.

    Thank you in advance for your help.

    Phil

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to subtract & add in IF, THEN, OR Statements

    Try

    =A1-(5*((A1>30)+1)

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

    Re: How to subtract & add in IF, THEN, OR Statements

    Which cells are you using? Assume you enter your amount in A1, then put this in B1:

    =IF(A1="","",IF(A1<30,A1-5,A1-10))

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    01-09-2012
    Location
    Seattle
    MS-Off Ver
    Excel -MS Office 365 Subscription
    Posts
    48

    Re: How to subtract & add in IF, THEN, OR Statements

    Solved.

    Thank you.

  5. #5
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to subtract & add in IF, THEN, OR Statements

    Another way

    =IF(A1="","",A1-5-(A1>=30)*5)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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. Reading If statements and formulating values from if statements
    By crnam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 05:20 AM
  2. If Sat subtract one day, if Sunday subtract tow days
    By Wskip49 in forum Excel General
    Replies: 3
    Last Post: 06-30-2012, 03:35 PM
  3. Replies: 1
    Last Post: 01-27-2012, 11:25 PM
  4. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  5. [SOLVED] operator statements, shorting when reusing one of the statements?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 02: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