JasmineCorp Directory   
  
Usenet News Group Archives!!!

Usenet Groups:

 

 

 

 

 

Re: Formula help - need more understanding.
--------------------------------------------------------------------------------------------
Newsgroup: microsoft.public.excel.misc
Posted by: =?Utf-8?B?Sm8gU2luZ2Vy?=
2007-05-19 14:29:19

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
> news:F97911E9-110D-4389-8A88-4F4B5F386647@microsoft.com...
> > 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?
>
>
>

 

 

 

More >> 

Domain Registration:
.com .org .net
.info .biz .us