Hello I did not know how to word this in the title, hopefully someone
will help me.

I need a cell to figure out how many bonus points another cell is
worth. Here is my question:

In cell b3 there will be a daily sales # average. in cell c3 I need
the formula to figure out if the sales average is greater than 5 if so
the result should be 25 (points) if it is between 4 - 4.9 the result
should be 20 (points) if is less than 4 the result should be 0 (Zero).


I am sure this will be easy for most people but I am stuck

Thanks in advance for your help.

Mike


--
manickmj
------------------------------------------------------------------------
manickmj's Profile: http://www.excelforum.com/member.php...fo&userid=8870
View this thread: http://www.excelforum.com/showthread...hreadid=388138