Round up or down for costs (invoice)

Hi I'm new with numbers but was good in excel. Now I try figure out how I can round costs in an invoice. For exampel:

In my row E10 I have the sum of a calculation let's say 1'200.- CHF. From this sum I need 8,33% which gives me in row E11 the sum of 99.96. Now I need to round this up or down. I wanted to add "round" to my formula in E11 which says =sum(E10)x8,33% but it won't work. I'm a little bit frustrated because with excel I was very fast and good but with numbers it seem's I'm to stupid to check the formulas *grrrr

Secondly I work with the german version not in english. I have to translate the formulas. Question: where (which row) do I have to round? E11 or already E10 and what exact formula is it to put in? Thank you for you help

iMac, OS X Mavericks (10.9.1)

Posted on Feb 26, 2014 6:54 AM

Mar 14, 2014 2:38 AM in response to angelibox

"E11 =VRUNDEN(ABRUNDEN(E10 * 8,33%; 2); 0,05)

although correctly in German it's =VRUNDEN(E10 * 8,33%, 0.05) I only needed comma after 8,33% and 0.05 (point)

I couldn't find a solution for rounding down (because this here is up)?"

VRUNDEN, like RUNDEN, will round up OR down to the nearest value meeting its rule. Here is a table showing values in 0.01 increments from 100.00 to 100.10 in column A, and the result of rounding to the nearest five hundredths, using VRUNDEN(A,0.05) in column B. Conditional formattig has been used to show the values that have been rounded down (blue) and the values that have been rounded up (yellow).

SGIII:

When I have 34.56 -> must become 34.55

When I have 34.58 -> must become 34.60

I need to round to the next decimal of 5!

I haven't found the solution to put the right formula when I have the invoice as follow:

E10 Total = 1'100.-

E11 8,33% = 91.63

E12 Total = 1'191.63

Do I need a extra row to put the formula in E11? Or a 4th row to put the EndTotal of 1'191.65? I can't just put it in E11 nor E12. Won't accept the formula as I mentioned it above."

If Zwischentotal 2, in E12, should be rounded, you can include that rounding in the formula in E12:

current: E12: =SUM(E10:E11)

revised: E12: =MROUND(SUM(E10:E11),0.05)

BUT all of the values in the table you display in your second post yesterday appear to be 'as calculated, with the display showing the result to the nearer hundredth of a Swiss Franc, with only one exception. The end total has been rounded to the nearest five hundredths of a Swiss Franc.

If that is correct,then the only place where VRUNDEN is needed is in the Endtotal row (as shown on the table below).

Here's a reconstruction of your tables, done in a single table, and with no rounding done to any results in column E except the last.

(Column F contains a copy of the same values as column E, formatted to display to the nearest hundredth.)

Regards,

Barry