<= Formula ?
 

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 (C540, C5-40 * 1.5.))

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

<= Formula ?
 

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

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

regards,
henrique.



"AJ" wrote in message
...
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 (C540, C5-40 * 1.5.))

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

<= Formula ?
 

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

"Henrique" wrote:

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

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

regards,
henrique.



"AJ" wrote in message
...
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 (C540, C5-40 * 1.5.))

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

<= Formula ?
 

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" wrote in message
...
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 (C540, C5-40 * 1.5.))

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

<= Formula ?
 

I would change

C5 - 40 * 1.5

to

(C5-40) * 1.5

or

(40-C5) * 1.5

depending on what the OP means with "the difference of 40 and C5"

Lars-Åke

On Sun, 13 Jul 2008 13:09:14 -0300, "Henrique" wrote:

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

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

regards,
henrique.



"AJ" wrote in message
...
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 (C540, C5-40 * 1.5.))

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

<= Formula ?
 

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


"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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 (C540, C5-40 * 1.5.))

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

<= Formula ?
 

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



"AJ" wrote:

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

"Henrique" wrote:

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

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

regards,
henrique.



"AJ" wrote in message
...
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 (C540, C5-40 * 1.5.))

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