| View previous topic :: View next topic |
| Author |
Message |
salexcosta
General User
Joined: 16 Aug 2012
Posts: 6
|
 Posted: Fri Aug 17, 2012 8:48 am Post subject: So, do you think you can answer this?? |
 |
|
Hi
I need my open office calc numbers to be in decimals but I only want whole numbers or 0.5. Is there a way to do this? I already have the following formula in the column: =AVERAGE(LARGE(G20:J20;1);LARGE(G20:J20;2))
Much appreciated  |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2731
Location: Egersund, Norway
|
| Posted: Fri Aug 17, 2012 11:53 am Post subject: |
|
|
| =MROUND(AVERAGE(LARGE(G20:J20;1);LARGE(G20:J20;2));0.5) |
|
| Back to top |
|
|
|
