Questions tagged [rounding]
4 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
- 206
- 2
- 8
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
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 ->…
Jeff Kaufman
- 3
- 1
-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…
