ROUNDUP help

[Joneye]

Im tying to double round up here, i.e. the end part /10*10 gives me a result of 27.20, i need it to round up, can i enter the formula with a roundup near the end say from here -- /10*10


=ROUNDUP(SUM('[Dashboard 2011.xls]2. Inventory'!$E$11/35),0)/10*10

 

[GlennUK]

Can you expain in English what rounding you want to achieve?

 

[Joneye]

Sadly i can not post data for this one.

The formula first part rounds up a simple division sum
939 / 35 = 26.81 (roundup gives me) 27

Second part of the formula is

27 / 10 = 2.7 then x 10 = 27.00

I need the 27.00 to roundup to 30.00

I hope this helps?

 

[GlennUK]

Isn't that just:

=ROUNDUP(SUM('[Dashboard 2011.xls]2. Inventory'!$E$11/35),-1)

?

 

[Joneye]

Indeed that works, so the minus one tells the forumla to? just so i understand why...

ps many thanks

 

[GlennUK]

That's rounding to -1 decimal places basically ( i.e. 1 to the left of the decimal place ).

 

[Joneye]

FAB many thanks.