Posted to microsoft.public.excel.worksheet.functions
|
|
<= 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
|