roundup formula

[Kiwi den]

I am trying to use a formula within a cell and want the answer rounded up

=ROUNDUP((235*25%)+235,0) THIS DOES NOT WORK

ANY THOUGHTS

 

[FDibbins]

What does "this does not work" mean?
Wrong answer?
No answer?
something else?

What were you expecting and what did you get?
I got 294.0

 

[dcardno]

In this case the ROUNDUP value is the same as the rounded result, because the intermediate value of 235 * 25% is 58.75, and the argument to the ROUNDUP function is 293.75.
Try:
ROUNDUP((233*25%)+233,0), which results in 292, while the normal ROUND function yields 291

 

[Kiwi den]

=ROUNDUP((D456*25%)+D456),0)

THIS IS THE FORMULA IN THE CELL.. WHEN SELECTED, EXCEL TELLS ME THERE IS AN ERROR IN THE CALCULATION

sorry for caps

 

[FDibbins]

Remove that 2nd-last )
=ROUNDUP((D456*25%)+D456,0)

You did not answer my questions?

 

[FDibbins]

You could also simplify that to...
=ROUNDUP(D456*1.25,0)

 

[dcardno]

You've got one too many right-parens. Try
=ROUNDUP((D456*25%) + D456, 0)
note no right-parenthesis after the second reference to D456

 

[Kiwi den]

=roundup(D456*25%)+D456,0) this still returns an error message, to few arguments...

D456=230 i would like 288 as answer

 

[FDibbins]

Take a look at post #6 , it eliminates all extra ()'s

 

[Kiwi den]

=ROUNDUP((D456*25%) + D456, 0) this returns an error message "the formula you typed contains an error"
the BOLD section is highlighted