 # 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