EXCEL

Occasional Visitor

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

1 Reply

@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")))