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.

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?

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.

OK - try this, then:

=ROUND(A1*C1,0)

Try this custom cell format for that column:

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

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.