formula help
 

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

One way:

=20*(B3=4) + 5*(B3=5)

In article ,
manickmj
wrote:

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

thank you so much, I have never seen that one but it helped me on my
next question also.

thanks again,
Mike


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