lzweifel
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 213
Hi,
This is very basic, but has me stumped.... I have a varying number of rows each with calculate hours * dollars. This results in a figure, dollars and cents. At the end of all the rows I have my total dollars. This formula is just a simple sum of all the rows.
What's happening is the SUBTOTAL =SUM(J26:J50) is not calculating properly, always out by a few cents. Here is a complete example of one row calculations as well.
Here is my row calculation: =IF(C26="","",(G26*I26))
It must be that the sum is rounding in some way and the rows are not, or the rows are rounding and the sum is not. The ROWS ARE CORRECT, I do not want to change them. If I calculate with a calculator with 2 decimal points it is correct.
Gosh, this was hard to explain, hope I made some sense of it.
L
This is very basic, but has me stumped.... I have a varying number of rows each with calculate hours * dollars. This results in a figure, dollars and cents. At the end of all the rows I have my total dollars. This formula is just a simple sum of all the rows.
What's happening is the SUBTOTAL =SUM(J26:J50) is not calculating properly, always out by a few cents. Here is a complete example of one row calculations as well.
Here is my row calculation: =IF(C26="","",(G26*I26))
It must be that the sum is rounding in some way and the rows are not, or the rows are rounding and the sum is not. The ROWS ARE CORRECT, I do not want to change them. If I calculate with a calculator with 2 decimal points it is correct.
Gosh, this was hard to explain, hope I made some sense of it.
L