Thread: Formula help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jo Singer[_2_] Jo Singer[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?