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