R rickmg Oct 25, 2004 #1 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
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 Oct 25, 2004 #2 What you've cooked up returns text for hours over 40. I'm sure that isn't what you want.
