+ Reply to Thread
Results 1 to 4 of 4

Question about =IFS() having trouble with my formula!

  1. #1
    Registered User
    Join Date
    05-15-2021
    Location
    Ireland
    MS-Off Ver
    2021
    Posts
    17

    Question about =IFS() having trouble with my formula!

    Question about =IFS() having trouble with my formula!

    Hi, am looking for some help. I can't seem to get my formulae right for this particular problem/ I want to put a value into one cell (A2 in my example) and have a number between 1-5 to appear as the result (E2) depending on certain terms. The input number is being compared to a High, Average and Low number. I'm looking for the formula to put in cell E2 to get the result I'm looking for.

    Any help would be greatly appreciated!!!

    Below are the terms of my =IFS

    If the number is greater than the High, result is 5
    If the number is greater than the average but less than or equal to the High is 4
    If the number is equal to the Average, result is 3
    If the number is less than the average but greater than or equal to the Low is 2
    If the number is less than the Low, result is 1

    A / B / C / D / E

    1 Number to Check / High / Average / Low / Result
    2
    Last edited by JoeKerr99; 05-15-2021 at 03:04 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,198

    Re: Question about =IFS() having trouble with my formula!

    Data in row 2

    =IF(A2>B2,5,IF(AND(A2>C2,A2<=B2),4,IF(A2=C2,3,IF(AND(A2<C2,A2>=D2),2,1))))

  3. #3
    Registered User
    Join Date
    05-15-2021
    Location
    Ireland
    MS-Off Ver
    2021
    Posts
    17

    Re: Question about =IFS() having trouble with my formula!

    Marry me!

    Thank you SOOOOO much! I'm not great with Excel and you've just really helped me out.

    Super awesome! Thank you!


  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,198

    Re: Question about =IFS() having trouble with my formula!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Having trouble answering an excel question.
    By Curzon88 in forum Excel General
    Replies: 3
    Last Post: 08-23-2017, 10:42 AM
  2. Replies: 2
    Last Post: 11-28-2016, 01:44 PM
  3. IF Formula trouble
    By Sammyg222 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-01-2016, 12:18 AM
  4. [SOLVED] Trouble with IF Formula
    By dsullivan_2013 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-01-2014, 10:33 PM
  5. Replies: 1
    Last Post: 05-11-2014, 08:28 PM
  6. Rookie VBA question - Trouble entering excel data in to a searchbox on a webpage
    By andba731 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2014, 08:52 PM
  7. Replies: 1
    Last Post: 09-19-2013, 12:07 AM

Tags for this Thread

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