Excel Formulas
I need to create a formula where it adds regular 40-hour pay plus overtime in
the same cell/formula. also, I need to create Conditional Formatting to highlight students who got 80+ on 5 consecutive tests. BH |
Excel Formulas
First for the OT
http://www.cpearson.com/excel/overtime.htm Second for the CF http://www.contextures.on.ca/xlCondFormat01.html Gord Dibben MS Excel MVP On Thu, 15 Nov 2007 19:29:01 -0800, Payroll <Payroll @discussions.microsoft.com wrote: I need to create a formula where it adds regular 40-hour pay plus overtime in the same cell/formula. also, I need to create Conditional Formatting to highlight students who got 80+ on 5 consecutive tests. BH |
Excel Formulas
Part 1 - =IF(A1040,(A10*15)+((A10-40)*7.5),A10*15)
Part 2 - =MIN(B1:F1)80 "Payroll" wrote: I need to create a formula where it adds regular 40-hour pay plus overtime in the same cell/formula. also, I need to create Conditional Formatting to highlight students who got 80+ on 5 consecutive tests. BH |
All times are GMT +1. The time now is 08:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com