# Decimal Situation....

This topic is 6064 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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.

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

The ROUND function worked perfectly!

Thank you!!!

##### Share on other sites

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

##### Share on other sites

This topic is 6064 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account