Custom Formula

Hi there! I want help!

I want to know how to insert a custom formula in excel that includes percentages and addition of them to the base value. This requirement must be common among a shopkeeper or for an on-line seller where he has the wholesale purchase price, the base selling price but wants to add a series of percentage values to make it his final selling price

Let me tell you an example:

Base selling price: 100
Fixed Carriage to charge from customer: 19%
Tax: 12.36%
Risk Cover Margin: 5%

So it's like: 100+19%+12.36%+5% = 140.39
I did this through the calculator but want to apply this on excel so that I can automatically have the final price from the base selling price.

Please help.

Vishesh's picture

Custom formula answered