Formula Help

[al97233]

Hello All,

I am trying to get a formula to work for the following equation. or discount on a particular product is 50/10/10 which I know is a .405 multiplier. The problem has been trying to get this to function on a spread sheet. I want to be able to enter the discount in cells as 50 [tab] 10 [tab] 10 [tab and have a cell return the value as .405. this will be done on multiple rows but each row will be a different set of values that will return a different multiplier. i thought this would be easy but i have been unable to figure it out.

thanks in advance for any help.
Al

 

[al97233]

if something is $1 then 50% off is .50 Then 10% off .50 is .45 Then 10% off .45 is .405

That part I know but entering in a cell to return that value was not working until I used ToadStools method.