<>= Formula ?

[AJ]

Can someone please help. I think this is basic, but I must be overthinking it.

I need a formula to multiply 1.5 to the difference of 40 and C5 if the cell
is over 40.

IF(C5 <= 40, 0, IF (C5>40, C5-40 * 1.5.))

Like I said, basic, but can't figure it out.
Thanks

 

[Henrique]

IF(C5 <= 40; 0; C5-40 * 1.5)

In BR we use ;
If doesnt work.. change ";" by ","

regards,
henrique.

 

[AJ]

Sorry - I received a 0 value for your formula below with "," as I got an
error using ";".
Anything else that could help?

 

[Rick Rothstein \(MVP - VB\)]

This is probably the formula you were looking for...

=IF(C5<=40,0,1.5*(C5-40))

However, you can do the same thing in a little easier fashion like this...

=1.5*MAX(0,C5-40)

This says if C5-40 is less than zero, multiply the 1.5 times zero (which
results in zero), otherwise multiply 1.5 times the difference.

Rick

 

[AJ]

Rick, that worked perfectly. Thanks for both of your help.

 

[daddylonglegs]

What's in C5?????

If you have hours in time format like 42:30 then modify Rick's suggested
formula as follows:

=1.5*MAX(0,C5-"40:00")*24