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!”
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