Hi i hope you can help me i need a formula for a greater than cell
basically i need the cell to read this
if a person gets 90% then please put $50.00 in the this cell if they get less than 90% please put a 0 in the cell
basically i am doing a spread sheet for bonuses and the guys get bonuses for the amount of contracts that are current with a 90% or more they get a $50 bonus i need the cell to state that but i cant figure how to do the formula i am close but not enough i have been doing the greater than formula and the if formula but havent gotten it to work can you help me?

---

Answer from Richard Rost:

If your percentage is in cell A1, then put this in A2:

=IF(A1>=0.90,50,0)

That says, "IF A1 is greater than or equal to.90, then put a 50 here, otherwise put a 0 here."

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx