Mar 10 2022 01:17 AM
hi all,
doing an assignment where i need to produce an IF statement, however excel is showing it is wrong, any help on whats wrong with the statement? TIA
=IF(X2<7.5,EXCELLENT,IF(X2>=7.5,GOOD,IF(X2>=15,FAIR,IF(>30,POOR,))))
if the value is between 0 and 7.5, i would like the condition to be excellent, if equal to or greater then 7.5 and less than 15, good condition, if equal to or greater than 15 but less than 30, fair condition, and equal to or greater than 30, poor condition.
any help would be greatly appreciated
Mar 10 2022 01:20 AM - edited Mar 10 2022 01:30 AM
@sophieexcel Your formula has some syntax errors.
=IF(X2<7.5,"EXCELLENT",IF(X2>=7.5,"GOOD",IF(X2>=15,"FAIR",IF(X2>30,"POOR"))))
This formula will not show an error, but it will not give you the correct result, as any value greater than 7.5 will always return GOOD. You need to place the IFs in reverse order.
So, this is what you really need:
=IF(X2>30,"POOR",IF(X2>=15,"FAIR",IF(X2>=7.5,"GOOD","EXCELLENT")))