9 Replies Latest reply: Jan 18, 2013 3:00 PM by Zhenya Virina

# Rounding

Hi All,

I am working with a straight table where i need to round some values from

100,000,000.00 to 100.00

AND

if value is only two decimal palaces 0.11 no action is needed.

How can I work this into a formula?

Thank you

• ###### Re: Rounding

Hi,

Try something like this:

=num(sum(Expression),0.00)

Regards,

-Khaled.

• ###### Re: Rounding

Try this

=round(sum(Expression),0.01)

it will round the values and display with 2 decimals

or if u want to list the first 2 decimals.

Goto the properties tab, select numbers theere u can modify the values accordingly..

or   =num(sum(Expression),0.01),' #,##0.00') it will exactly return 2 values...

• ###### Re: Rounding

That does not work for me. Any other suggestions?

• ###### Re: Rounding

can u post a sample .so that we can figure out where exactly ur missing?

• ###### Re: Rounding

Here you go. Thank you for your help

• ###### Re: Rounding

where exactly ur getting wrong..

i am able to display for the 2 decimals..

the thing is u marked in numbers as money format..

can u change that to decimal...

• ###### Re: Rounding

Dear zvirina123,

in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.

Thanks,

Mukram.