I need some help with setting up multiple conditions with the IF function .


eg- incentives for a company's salesmen depends on the number of sales per month .

<10 - poor
10-20 - good
21-29 - excellent
30 and above - outstanding

The formula I am trying to use is

=IF(no.<10,"poor",IF(21>no.>=10,"good",IF(30>no.>=21,"excellent",IF(no.>=30,"outstanding"))))

where no. is the number of sales per month but the formula is not working .

Please help