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
|