Rounding Formula

[EnigmaMatter]

Hello,

I am writing valuation software.

The output of the software provides a #.

I want that # to be ROUNDED DOWN to the nearest hundreth (which I know is

Please Login or Register  to view this content.

), UNLESS the last two digits of the # are 95 or higher (in which case I want it to ROUND UP to nearest hundreth).

Example: 345 = 300, 374 = 300 390 = 300...395 = 400

Any and all help is appreciated.

[Pete_UK]

You can use this approach:

=ROUNDDOWN(A1+5,-2)

Hope this helps.

Pete

[Ron Coderre]

Try this:

Please Login or Register  to view this content.

[EnigmaMatter]

How deceptively simple.

Both formulas work.

What is the difference between the two?

[Ron Coderre]

Like so many solutions in Excel...more than one way to achieve the same results.
However, since you asked:
The FLOOR function rounds down to a multiple of a specific value, 100 in this case
The ROUNDDOWN function rounds down to a specific number of decimal places.