thank you roger but my original question is - why doesn't R1 and R2 have the
same final answer? i take it it's a rounding issue? if so that is a huge
difference.



"Roger Govier" wrote:

Hi Jo

18.46 * 95% = 17.537
17.54 - 17.537 = .003
0.003 * 174 * 12 = 6.264

36623.52 - 36617.26 = 6.264
--
Regards

Roger Govier


"Jo Singer" wrote in message
...
thank you tim...
hmmmm.. looking back at my calculations..

cell F13 cell F14
cell F15
R1: =18.46*95% answer:17.54 =(F13*174)*(12) answer: 36617.26
R2: 17.54(manually entered) =(F13*174) answer:3051.96
=F14*12 answer: 36623.52


"tim m" wrote:

I get 36623.52 for both of them. Is your formatting the same of all
cells?
Brackets all the same?

"Jo Singer" wrote:

Hi:
Excel calculates as:

cell F13 cell F14
cell F15
R1: 17.54 =(F13*174)*(12) answer: 36617.26
R2: 17.54 =(F13*174) answer:3051.96 =F14*12
answer:
36623.52

Why is R1 and R2 final answers different? should they not be the
same?