If the value in cell A1 equals 2, the IFS function returns Good. If the value in cell A1 equals 3, the IFS function returns Excellent. If the value in cell A1 equals another value, the IFS function returns No Valid Score. Note: instead of TRUE, you can also use 1=1 or something else that is always TRUE. Here's another example.
So i will try break down what im trying to do, on one sheet i have the above headings with the relevant data. On another sheet i have the first column with the code, the second column with the quantity i want and the third column with the price.
If the value in cell A1 is less than 60, the IFS function returns F. If the value in cell A1 is greater than or equal to 60 and less than 70, the IFS function returns D.
If the value in cell A1 is greater than or equal to 70 and less than 80, the IFS function returns C. If the value in cell A1 is greater than or equal to 80 and less than 90, the IFS function returns B. If the value in cell A1 is greater than or equal to 90, the IFS function returns A.
![Does ifs function work on excel for macro Does ifs function work on excel for macro](/uploads/1/2/5/4/125465869/615933392.jpg)
Note: to slightly change the boundaries, you might want to use '.