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
=IF(no.<10,"poor",IF(no.<21,"good",IF(no.<30,"excellent","outstanding")))
I assume you have a range named "no." somewhere
not a professional, just trying to assist.....
Thnx fr reply but still not working
well exactly what is not working?
The formula is not giving the required answer when the value is changed
is the value in a cell with a named range of "no"? Or if not, how does the formaula "see" the cell where the value is entered?
no. just refers to the cell where the number of sales per month are entered
what value when entered gives the wrong answer, and what answer does it give?
please check it out .
well that is what you specified:
<10 - poor
10-20 - good
21-29 - excellent
30 and above - outstanding
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks