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

 

[Kiwi den]

=ROUNDUP(D456*1.25,0) tried that still error message

 

[FDibbins]

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

I enter that exact formula with no problems

 

[FDibbins]

=ROUNDUP(D456*1.25,0) tried that still error message

I entered that with no problems, too.

Are you getting an error message while trying to ENTER the formula, or is the formula entering OK but the answer is showing an error?

 

[Kiwi den]

=ROUNDUP(D456*1.25,0) this also returned an error message

 

[Kiwi den]

entering is fine, it is the answer that is showing the error message

 

[FDibbins]

OK so what EXACTLY is in D456?

 

[dcardno]

Sorry, Kiwi den, but I can also enter the formulas (both the original and FDibbins' suggested alternative) without any error. The only way I can generate an error is to put a text value in the referent cell...
What error are you getting?

 

[Kiwi den]

=ROUNDUP(D456*1.25,0) message reads " The formula you typed contains an error"
highlighted is 1.25,0.
i have the cell set to a number, have tried setting i t to general, same problem.

 

[Kiwi den]

230 formatted to "general", i have tried formatiing this to number with the same result

 

[FDibbins]

Formatting only changes the appearance of a cell, not it's underlying contents. If you have a text number in a cell, formatting will not change that.
However, multiplying a text number by 1 (or 1.25) should fix that.

Try this for me. In an open cell, type in
=ISNUMBR(D456)...should give FALSE
In another cell, type in =LEN(D456)