Calculate final price after discount

Hi guys,

I`m sure this is extremely simple but I am not getting success.

I want to calculate 30% off a price let's say an item for £12 and calculate 30% off, so what the final price is. Ideally I want to use one or 2 cells max.

Can anyone help with a suitable formula? I am just getting a discount value not the amount of the item!

Thank you

Originally Posted by davsth

original price * (1-discount%)

12 * (1-30%)

12*(1-0.3)

Awesome thank you!