+ Reply to Thread
Results 1 to 2 of 2

IF statement with multiple criteria

  1. #1
    Forum Contributor
    Join Date
    07-18-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    192

    IF statement with multiple criteria

    Hi Friends

    I want to create IF formula with the following conditions.

    If cell A1 is less than 55,000,000, the answer should be NIL. If it is between 55,000,000 to 65,000,000, the A1 multiply by 2.50%, If it is between 65,000,000 to 75,000,000, then ((65,000,000 minus 55,000,000)*2.50% PLUS ((75,000,000 - Cell A1)*2.25%). If cell A1 is greater than 75,000,000, then ((65,000,000 minus 55,000,000)*2.50%) PLUS ((75,000,000 - Cell A1)*2.25%) PLUS ((Cell A1 - 75,000,000)*2.00%).

    Thanks in advance
    cheers

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,373

    Re: IF statement with multiple criteria

    I dont' check the results:

    =IF(A1<55000000,"Nil",IF(AND(A1>=55000000,A1<=65000000),A1*2,5%,IF(AND(A1>=65000000,A1<=75000000),(65000000-55000000)*2,5%+((75000000-A1)*2,5%),IF(A1>75000000,((65000000-55000000)*2,5%)+((75000000-A1)*2,5%)+((A1-75000000)*2%)))))

+ 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. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  2. [SOLVED] If statement that will look among multiple criteria and generate a statement
    By liz5818 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2013, 04:12 PM
  3. Multiple criteria if statement
    By marlin5124 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-11-2011, 03:18 AM
  4. If statement with multiple criteria
    By Savitri in forum Excel General
    Replies: 2
    Last Post: 06-06-2010, 11:25 PM
  5. IF statement using multiple criteria
    By Joe Gieder in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2005, 05: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