+ Reply to Thread
Results 1 to 5 of 5

If a = between b&c it will equal d, or if a = between e&f it will equal g, or if etc etc

  1. #1
    Registered User
    Join Date
    11-22-2015
    Location
    Melbourne, Australia
    MS-Off Ver
    MS Office Standard 2013
    Posts
    2

    If a = between b&c it will equal d, or if a = between e&f it will equal g, or if etc etc

    Hi guys,

    I am new to this forum and not an excel master however i need help with a formula... i will try my best to explain...

    If A = between B ($5,000) & C ($9,999) it will equal D ($350), or if A = between E ($10,000) & F ($19,999) it will equal G ($450), or if A = between H ($20,000) & I ($29,999) it will equal J ($600), or if A = between K ($30,000) & L ($35,000) it will equal M ($750)

    I hope this makes sense... i need help with a formula..

    so far i have... =IF(AND(A39>=A45,A39<=B45),"$350","No") and it works however i have 3 other sums in need to add in to this formula and i dont know how to figure it out.

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

    Re: If a = between b&c it will equal d, or if a = between e&f it will equal g, or if etc e

    Set up a lookup table
    Something like this example

    EFLookup.xlsx

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: If a = between b&c it will equal d, or if a = between e&f it will equal g, or if etc e

    if you just need a simple lookup test this would work (sort of a take off of what Jonmo1 gave you)... =LOOKUP(A39,{5000,10001,20001,30001},{350,450,600,750})
    but if you need to compare it to values in B, C, D, E etc then you might need more of an if then stmt with each cell spelled out.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    11-22-2015
    Location
    Melbourne, Australia
    MS-Off Ver
    MS Office Standard 2013
    Posts
    2

    Re: If a = between b&c it will equal d, or if a = between e&f it will equal g, or if etc e

    WONDERFUL!!!!! HUGE thank you for your help and expertise

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

    Re: If a = between b&c it will equal d, or if a = between e&f it will equal g, or if etc e

    You're welcome

+ 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] IF date is greater than or equal to X but less than or equal to y
    By LloydGilmore in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-09-2019, 05:35 AM
  2. [SOLVED] Populate count & sum based on equal to & not equal to factors
    By jscalem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-20-2015, 01:20 PM
  3. [SOLVED] Basic equal and not equal not working?
    By petermichael in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-18-2015, 09:25 AM
  4. [SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values
    By AliciaRenee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 03:57 PM
  5. Scoresheet with Equal Ranks - need to identify equal placings separately
    By Caroleh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 02:59 AM
  6. When is equal not equal? Answer: In 2010
    By natefarm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 06:21 PM
  7. lower and upper case equal on spreadsheet but not equal in VB
    By don in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2005, 09:06 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