Formating the formula to display two decimal points

**chrism_production** · 07-24-2009, 12:59 PM

Hello,

Using Excel 2007: I have a spreadsheet that is calculating several formulas and placing the sum in specific cells. This works well, except; because of the extensive calculations, there are sometimes 15-25 numbers after the decimal. For example, in some cases, the sum displays as 25.3654896523658

I know that I can FORMAT the cell to display a specified number of decimals, however, how do I format the FORMULA to only calculate to TWO decimals. In other words, how do I direct the formula to round off to two decimals in the sum so the above example would read 25.36 in the formula bar.

Thank you in advance for the input.

-Chris

**ConneXionLost** · 07-24-2009, 01:02 PM

Hi Chris,

Just use the ROUND function:

=ROUND(A1,2)

replace A1 with your formula.

Cheers,

**chrism_production** · 07-24-2009, 01:28 PM

Awesome! I think this might work. Cheers.

**archcherub** · 02-14-2014, 01:09 AM

Oooo! I just tried the ; sign instead of , and it works!

Thanks thanks!

**archcherub** · 02-14-2014, 12:52 AM

Sorry for bringing out an old thread, but I am struck with a similar problem, and I hope some kind soul can help.

I have the same problem with TS, I read the reply and I understand the followin
=round(2.364,2)
The end-result would be returned as 2.36 (2decimal points)

But what if instead of a number, I had to input a formula. In this case, I have to calculate my sales tax of 7%. (formula for example is F72*7%)

Using ConnexionLost suggestion of =Round(a1,2) does not work.
=Round(F72*7%,2)

I tried =Round((F72*7%),2) and it failed too
similarly for other formulas for A1.

Any help appreciated!
Thanks!

**FDibbins** · 02-14-2014, 12:55 AM

Welcome to the forum arch and Im sure we can help.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.