IF Function

[mrsmburkes]

Can someone put this scenario in an IF Function formula:

"Click in cell B14 and use the IF function to determine the Bonus to be paid employees each Quarter. If the value in cell B12 is less than or equal to $50,000, then each employee will receive $500. If the value is not less than or equal to $50,000, then the Bonus amount will be $0.

 

[6StringJazzer]

Here is the formula to use in B14, but this reads like a homework problem. Are you asking us to do your homework for you?

This assumes that B14 is for a single employee.
=IF(B12<=50000,500,0)

 

[mrsmburkes]

Thank you for your help!