Get instant live expert help on I need help with bonus calculation excel sheet

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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