Only calculate the first two points of a decimal number

[MrPig]

Is there a way in Excel to only calculate the first two points of a decimal number?

For example, I have a forumla that produces the result 0.332521 - and I only want my calculation to be based on 0.33 (with no regards to the rest of the numbers), is there a way to either limit my calculation, or to make my result produce a two decimal answer (and not just in the formatting sense?)

Thanks

 

[MrPig]

Sorry!

=round()

Of course!

 

[GlennUK]

There is the menu command Tools/Options/Calculation/Precision as displayed.

So settings your cell formatting to only show 2 decimal places and having this option would probably do what you want.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.