Excel Calculation with IF and MIN Functions

preview_player
Показать описание
Using the IF and MIN functions to calculate an effort bonus for students. Students spent x minutes working. Bonus is the amount of hours more than 20 divided by 2. The max bonus is 5 and students that don't earn a bonus should have a blank cell.
Рекомендации по теме
Комментарии
Автор

Sir Ralph.. You are genius and legend in this platform but very less subscriber believe or not.. I made aware my country people to seek your help.. Alhamdulillaah

Shabazgold
Автор

So, please do put your videos on multiple platforms and go for live to... So we can ask you questions... Thanks for your help

Shabazgold