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

 

[joeu2004]

=ROUNDUP(D456*1.25,0) message reads " The formula you typed contains an error"
highlighted is 1.25,0.

Wild guess: try =ROUNDUP(D456*1.25;0) -- a semicolon between parameters instead of a comma.

 

[FDibbins]

Wild guess: try =ROUNDUP(D456*1.25;0) -- a semicolon between parameters instead of a comma.

hmm good call

 

[Kiwi den]

Thanks guys, I took this file to another machine and it worked fine.... not sure what went wrong, but will try and address a reinstall of Excel

 

[joeu2004]

I took this file to another machine and it worked fine.... not sure what went wrong, but will try and address a reinstall of Excel

Reinstallation should be unnecessary. It should be done only as a last resort.

Did you try my suggestion about using semicolon instead of comma for the parameter separator.

The problem might simply be the regional configuration (control panel) on the computer. Or if you use Office 365, however the "cloud" version determines regional differences.

(I don't know anything about Office 365. I avoid it like the plague.)

 

[Kiwi den]

reinstallation should be unnecessary. It should be done only as a last resort.

Did you try my suggestion about using semicolon instead of comma for the parameter separator.

The problem might simply be the regional configuration (control panel) on the computer. Or if you use office 365, however the "cloud" version determines regional differences.

(i don't know anything about office 365. I avoid it like the plague.)

great call!!!!!!=roundup(d456*1.25;0) worked thanks to all that answered