formula help

[manickmj]

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

[JE McGimpsey]

One way:

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

In article <manickmj.1sdvmk_1121720740.1813@excelforum-nospam.com>,
manickmj <manickmj.1sdvmk_1121720740.1813@excelforum-nospam.com>
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

[manickmj]

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

thanks again,
Mike