I added a column into the weldment cut list I call totals. Each cell is the product of Qty and Length. No problems. qty (3) * length (5 1/8) = 15 3/8 OR 3 * 5.125 = 15.375
I now want a total of all of one type so I use =sum() and have come up with some strange numbers.
If the units is decimal 5.125 + 5.125 + 5.125=15.375
If the units is fraction 16 (round to nearest) 5 1/8 + 5 1/8 + 5 1/8 = 15! only the int is figured in the equasion
Just for fun I also did =E2+23+E4 and got the same results.
See the pictures.
Anyone have a clue??