Overtime Pay formula

R

rickmg

I've never created a MAX, if indeed that is how it comes about, what
cooked up looks like this... =IF(B4>40,"(B4-40)(.5*C4)",0
 
M

Myrna Larson

What you've cooked up returns text for hours over 40. I'm sure that isn't what
you want.
 
Top