Formating the formula to display two decimal points

**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!