Formula help
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?
|