To see less ads Register or Login ----- Daily Fantasy Sports games 18+

excel query limitting formula to 2 decimal places

A forum to discuss or share knowledge of spreadsheets.
Post Reply
User avatar
barry
FISO Knight
Posts: 18871
Joined: 13 Oct 2005, 18:43
Location: moving into fisodas towers
Contact:

excel query limitting formula to 2 decimal places

Post by barry »

ok so I know how to limit cells to 2 decimal places by formatting the cell, but when that cell is used in a calculation it appears to calculate the full figure including the trailling decimal places.

there must be an easy fix for this.....right???

User avatar
rossn13
Grumpy Old Man
Posts: 3899
Joined: 14 Aug 2009, 11:46
Location: Shenzhen, China
FS Record: 12th TFFE 09/10

Re: excel query limitting formula to 2 decimal places

Post by rossn13 »

=ROUND(Number,2)

User avatar
barry
FISO Knight
Posts: 18871
Joined: 13 Oct 2005, 18:43
Location: moving into fisodas towers
Contact:

Re: excel query limitting formula to 2 decimal places

Post by barry »

cheers!

User avatar
Pincher
Grumpy Old Crab
Posts: 3378
Joined: 13 Oct 2005, 18:32
Location: , location, location ...
FS Record: Allys Tartan Army

Re: excel query limitting formula to 2 decimal places

Post by Pincher »

Though you shouldn't really be rounding here - only at the end of your calculations, else the books may not balance!

User avatar
barry
FISO Knight
Posts: 18871
Joined: 13 Oct 2005, 18:43
Location: moving into fisodas towers
Contact:

Re: excel query limitting formula to 2 decimal places

Post by barry »

Pincher wrote:Though you shouldn't really be rounding here - only at the end of your calculations, else the books may not balance!

it's the age old problem of manually checking one system with another, both of which operate differently.... data is worked out to infinite decimal places but only calculated using 2 decimal places, when trying to "proof" the calculations to find any errors, we also need the data to work to 2 decimal places, rather than, as you say, calculating the data accurately and only using 2 decimal places to keep the "report" tidy.

User avatar
Shaggy365
Dumbledore
Posts: 7440
Joined: 19 Feb 2007, 15:24
Location: Promoting choir website
Contact:

Re: excel query limitting formula to 2 decimal places

Post by Shaggy365 »

Takes me back to the days when I had to report the company's profit to the nearest £000. There was more time spent adding up & subtracting in the meetings to make sure it was all consistent with itself than anything else. People didn't mind if we'd lost £50k in the month, as long as the numbers added up. :roll:

User avatar
barry
FISO Knight
Posts: 18871
Joined: 13 Oct 2005, 18:43
Location: moving into fisodas towers
Contact:

Re: excel query limitting formula to 2 decimal places

Post by barry »

Shaggy365 wrote:Takes me back to the days when I had to report the company's profit to the nearest £000. There was more time spent adding up & subtracting in the meetings to make sure it was all consistent with itself than anything else. People didn't mind if we'd lost £50k in the month, as long as the numbers added up. :roll:
£50k of lost time in meetings adding and subtracting ? :lol:

View Latest: 1 Day View Your posts
Post Reply

Return to “Spreadsheets”