Results 1 to 4 of 4

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

Threaded View

  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.

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