Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up down or anywhere
I have to fill in a form for the dreaded tax office. Now this form needs to
be correct only to 2 decimal places, therefore discarding any number after that without rounding the thrid decimal place up. Is there are format to use on the whole work book? Also any calculations done with that figure should only use those 2 decimal places but Excell keeps using the whole figure, can this be stopped also? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up down or anywhere
It used to be the case that income was always rounded down to the nearest £
and outgoings and allowances was always rounded up to the nearest £. The advantage was marginal but gives a satisfaction of having won something from the tax office. If this is still the case (read the small print) you don't want go rounding everything the same way. This applies only to the amount displayed on the screen. Internally, Excel is accurate to a number of decimal places. The formula are - =ROUNDUP(A1,2) =ROUNDDOWN(A1,2) Regards. Bill Ridgeway Computer Solutions "Dawn Ellis" <Dawn wrote in message ... I have to fill in a form for the dreaded tax office. Now this form needs to be correct only to 2 decimal places, therefore discarding any number after that without rounding the thrid decimal place up. Is there are format to use on the whole work book? Also any calculations done with that figure should only use those 2 decimal places but Excell keeps using the whole figure, can this be stopped also? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round up | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
how do I round up? | Excel Worksheet Functions | |||
How can I round UP to to the next ,50? | Excel Worksheet Functions | |||
How can I round UP to to the next ,50? E.g. 2,3 should become 2,5. | Excel Worksheet Functions |