Decimal Situation....

[macmangler]

Hi...my calculation is multiplying an amount by 120%, so for example, $49.03 x 120% = $58.836

How do I round it to only 2 decimal places? The result I am hoping to get is $58.84

I am familiar with Ceiling and Floor, but they work on whole numbers, not on decimals.

Thanks in advance!!!

[tv_kid]

How do I round it to only 2 decimal places? The result I am hoping to get is $58.84

Try the 'Round' function.

HTH

[Lee Smith]

I hate to tell you, but 20 percent of 49.03 equals 9.806 however, 120% of it equals 58.836.

Once you have your decimal correct, then the Round (yournumber; 2) will do what you need.

HTH

Lee

[macmangler]

The ROUND function worked perfectly!

Thank you!!!

[macmangler]

Sorry.. was a typo..I meant marked up 20%... but thanks!! I never used the round function before.