Hi,

Need help with an excel formula to work out cost price for an item after applying a discount. I am only new to this so if anyone can help it would be much appriciated.

I have following cells which have the data I need to look at to get final cost.

E10 - Has cost price per meter before discount

D10 - Has size in meters of lenth of metal

F10 - Has discount figure (46%)

G16 - Is where I want discounted price to appear.

(I need a formula to multiply cost price x size of length of metal, minus the discount figure).

Tks Mike

Need help with an excel formula to work out cost price for an item after applying a discount. I am only new to this so if anyone can help it would be much appriciated.

I have following cells which have the data I need to look at to get final cost.

E10 - Has cost price per meter before discount

D10 - Has size in meters of lenth of metal

F10 - Has discount figure (46%)

G16 - Is where I want discounted price to appear.

(I need a formula to multiply cost price x size of length of metal, minus the discount figure).

Tks Mike

## Comment