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)

 

[manickmj]

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

thanks again,
Mike