<>= Formula ?

  • Thread starter Thread starter AJ
  • Start date Start date
A

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
 
IF(C5 <= 40; 0; C5-40 * 1.5)

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

regards,
henrique.
 
Sorry - I received a 0 value for your formula below with "," as I got an
error using ";".
Anything else that could help?
 
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
 
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
 
Back
Top