Get the number by replacing last 2 digits with 00

[bittubadri]

B2 contains 5 digit +ve integer.

In output cell D2, I want the 5 digit number containing first 3 digits & then suffixed by 00.

Example:
B2=35532, D2=35500
B2=35567, D2=35500

How to accomplish?

[MarvinP]

Hi bittubadri,

Try in D2

Please Login or Register  to view this content.

[josephteh]

Use =MROUND(B2,100) to round to nearest hundreds, =CEILING(B2,100) to round-up and FLOOR(B2,100) to round-down.