“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Why doesn't this work in Excel : =IF(AND(H5=''YES'',MIN(B5:E5)>=8000),"BONUS","NO BONUS")

Solved by O. C. in 30 mins

what is the formula for a qtrly bonus amount of $70,800. If you make between 37500-62500 you get a bonus of 40% anything above 62,501 you get 50% bonus.

Solved by V. L. in 24 mins

Use the IF function to complete the "Time Bonus $" column of table 1. If an employee earns a time bonus (i.e., the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "Job Pay" for that project times the bonus percentage in cell M11. Otherwise "Time Bonus $" is 0. [8 points]

Solved by K. D. in 19 mins

I need an if statement to calculate the bonus amount if the sales are higher than 300000. a7=300000 a8=0.5% (bonus amount) bonus cells are e11-e17 (employees) How do I do this?

Solved by Z. Y. in 28 mins

Graphs corresponding to calculation in Summary sheet

Solved by B. Y. in 26 mins