# Formula to work out pricing including percentage mark-up & rounding

1. ## Formula to work out pricing including percentage mark-up & rounding

Could someone please create an Excel sheet for me? I need to put prices (in euro) and then add %10 to each price. In the end, I have to round them.
I tried to do it myself but it won't work for prices like 0,050. It just shows 0.

Here's an examle:
Quantity: 4000
Unit price: 0,050
Unit price after %10 added: A (for example)
A * quantity = ?
And round it.

Thanks.

2. ## Re: Need help with making a proforma

Welcome to the forum!

This has nothing to do with a proforma - the title is completely misleading. Please read our rules on thread titles - I will change yours for you this time.

You have not made it clear how you want the rounding to work - traditional rounding or round up? And to how many decimal places?

3. ## Re: Formula to work out pricing including percentage mark-up & rounding

Assume this:

A1 = quantity (4000)
B1 = unit price (0,050)
C1 = mark-up price (=B1*1,1)
D1 = total (=A1*C1)

Now we need to know how you want the rounding done.

4. ## Re: Need help with making a proforma

Oh, so sorry about that... thank you for correction.

By rounding I mean like this:
15,227 -> 15,000
or 233,778 -> 234,000

5. ## Re: Formula to work out pricing including percentage mark-up & rounding

OK - try this, then:

=ROUND(A1*C1,0)

6. ## Re: Formula to work out pricing including percentage mark-up & rounding

Thank you. But when I type 0.050, it turns it to 0.05! How can I prevent this to happen?

7. ## Re: Formula to work out pricing including percentage mark-up & rounding

Also there's another problem:
Attachment 620009

8. ## Re: Formula to work out pricing including percentage mark-up & rounding

Try this custom cell format for that column:

_-* #.##0,000_-;-* #.##0,000_-;_-* "-"??_-;_-@_-

9. ## Re: Formula to work out pricing including percentage mark-up & rounding

It worked!! THANK YOU SO SO MUCH!
God bless!

10. ## Re: Formula to work out pricing including percentage mark-up & rounding

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1