My daily job requires me to issue a quotation to customer. In most cases I need to calculate how many percent I should increase the price.

Using a normal calculator or windows calculator to calculate percentage or adding a percentage is easy.

For example, I purchase a 98.00 dollar RAM and sell it 35% higher. Using a calculator, I will just press

**98** then

**+** then

**35** then

**%** then

** =**. I got 132.2.

This is easy if it's only for 1 item. But if I need to calculate a few item, then I will start making a mistake.

A friend had thought me using Microsoft Excel formula and here's 2 type of calculation involving percentage that I will use when preparing a quotation with Microsoft Excel.

**1. Calculate Percentage by deciding selling price.**
Using this formula, I will need to play around with my selling price to get the percentage.

The formula is:

** =(Price-Cost)/Cost**

**2. Calculate selling Price by deciding Percentage**
Using this formula, will need to decide how many percent I want to increase or maybe decrease my selling price.

The Formula is:

**=Cost*(1+Percentage)**
Please note that in the example, Price and Cost cells is Number formatted, while Percentage cells is Percentage formatted.

I wanted to thank you for this great read!! I definitely enjoying every little bit of it Smile I have you bookmarked to check out new stuff you post.

ReplyDeleteCommercial Audio Visual Design & Commercial AV System integration & Commercial AV installation Southbay