Questions tagged [rounding]
6 questions
3
votes
1 answer
Excel rounding errors
In a new worksheet (I'm using Excel 2013), starting in the top left, I type:
A
B
C
=18.6 + 67.2
=A1-85.8 = 0
=(A1-85.8) * 1000000000000
Expectation
A
B
C
85.8
TRUE
0
Actual Result
A
B
C
85.8
FALSE
0.014210855
I'm…
Bob Sammers
- 226
3
votes
1 answer
Inkscape Corners / Fillet
I tried to use the path effect 'Corners (Fillet/Chamfer)' to round the corners of a shape. Unfortunately, this is not working on all corners. Some do not round the exact radius that is set.
I made a circle object with the same radius and there is a…
Reinout Depoorter
- 31
- 1
- 2
1
vote
1 answer
Issue that Excel is not displaying enough decimal values for number with repeated decimals
I have an odd issue that I've never come across, and it seems to be specifically to one sheet of an excel file I compiled.
The sheet includes some very precise astronomical formulae, and sometimes the calculated numbers need to he accurate to 12…
0
votes
3 answers
Impose maximum digits on numbers in cells, regardless of position of decimal point?
I have a spreadsheet with the number of units of different investment funds, and the price per unit of each (in the same row).
Some of these “price per unit” values can have more than 10 decimal places, e.g. 5.6343268597991. Some of the numbers of…
mike rodent
- 774
0
votes
2 answers
Format number in Excel to align decimals but also remove decimal point optionally based on size of number
I'd like to create a publishable data table in Excel. Numbers may range from 0.010 to 1,000. I need to have similar significant figures and aligned decimal points. This is what I am looking for as display:
0.131 -> 0.1310
1.3 -> 1.300
130 ->…
-1
votes
2 answers
How to display values starting from the thousands digit
I have a number of cells, each with a number up to the millions digit.
I have been tasked to round each value to the nearest thousands digit and then make the cells ONLY show the numbers from the thousands digit and upwards.
To give a visual…
