Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
decimal places in calculations
Can I force excel to use the exact value obtained by multiplying a number
which has six decimal places rounded to three places by a constant rather than the value got by using the full six places in the calculation? eg 1.105566 x 24 = 26.533484 but 1.106 x 24 = 26.544. I'm a tyro at both excel and maths and the answer may be obvious. I want to align the results from a capital gains calculation made by hand with one from a tax program. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
decimal places in calculations
ToolsOptionsCalculation tab, check "Precision as displayed"
Check HELP first so you know what you're doing -- Kind regards, Niek Otten Microsoft MVP - Excel "Peter_jay_01" wrote in message ... | Can I force excel to use the exact value obtained by multiplying a number | which has six decimal places rounded to three places by a constant rather | than the value got by using the full six places in the calculation? | eg 1.105566 x 24 = 26.533484 but 1.106 x 24 = 26.544. I'm a tyro at both | excel and maths and the answer may be obvious. I want to align the results | from a capital gains calculation made by hand with one from a tax program. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
decimal places in calculations
=ROUND(1.105566,3) = 1.106
Is that what you want ? Regards Trevor "Peter_jay_01" wrote in message ... Can I force excel to use the exact value obtained by multiplying a number which has six decimal places rounded to three places by a constant rather than the value got by using the full six places in the calculation? eg 1.105566 x 24 = 26.533484 but 1.106 x 24 = 26.544. I'm a tyro at both excel and maths and the answer may be obvious. I want to align the results from a capital gains calculation made by hand with one from a tax program. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many decimal places can a cell display? | Excel Worksheet Functions | |||
Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
Excel defaulting to 3 decimal places when using the gen. format | Excel Discussion (Misc queries) | |||
Max decimal places | Excel Discussion (Misc queries) |