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
Bookmarks