| View previous topic :: View next topic |
| Author |
Message |
hcates
General User
Joined: 20 Aug 2006
Posts: 6
|
 Posted: Fri Sep 22, 2006 11:44 am Post subject: Rounding question - I'm sure the answer is obvious |
 |
|
I need to have the result of a formula rounded to 2 decimal places. In Excel, the formula would be =ROUND(2*A5*B5,2) - this isn't working in Calc. I can get it to round to no decimal places but that's not what I need.
What am I missing?
Thanks,
Heather |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Sep 22, 2006 12:34 pm Post subject: |
|
|
Function parameters are separated by semicolons.
=ROUND(2*A5*B5 ; 2)
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
