Multiplying 2 Columns

[estone4009]

Here is what I need:

Anything in column A with a value higher than 80 then it takes the amount over 80 and multiplies it to column D to equal column E.

 

[gizmo1973]

in cell e1 type =if(a1>80,a1*d1,0)

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[estone4009]

Close but not exact. If A1=100 then I only need it to multiply the last 20 not the full 100.

 

[gizmo1973]

Ah got you, hang on BRB

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[GoDawgs]

=if(a1>80,(a1-80)*d1,0)

 

[gizmo1973]

=IF(a1>80,(a1-80)*d1,)

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[GlennUK]

=MAX((A1-80),0)*D1



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.