I've Googled the newsgroups and the knowledge base, and can't find anything
on this. Is it possible to set up a loan calculator with Word's limited
math functions?

Ed

Probably, but I wouldn't recommend it if you have any alternative.

If you really want it, post the calculations and I, or someone else, will
see if they can be translated into Word.

--
Enjoy,
Tony


"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:(E-Mail Removed)...
> I've Googled the newsgroups and the knowledge base, and can't find
anything
> on this. Is it possible to set up a loan calculator with Word's limited
> math functions?
>
> Ed
>
>

Hi Ed,

To see how to do this and a wide range of other calculations in Word, check
out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Cheers


"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:(E-Mail Removed)...
> I've Googled the newsgroups and the knowledge base, and can't find
anything
> on this. Is it possible to set up a loan calculator with Word's limited
> math functions?
>
> Ed
>
>

Hi Ed:

It "could", but it's not safe to use it like this. Word's math functions do
not have sufficient precision to calculate amortisation accurately.

Use Excel: it's made for the job. You can automatically insert the results
Excel produces into your Word document.

Cheers


On 2/3/06 1:48 AM, in article (E-Mail Removed), "Ed"
<ed_millis@NO_SPAM.yahoo.com> wrote:

> I've Googled the newsgroups and the knowledge base, and can't find anything
> on this. Is it possible to set up a loan calculator with Word's limited
> math functions?
>
> Ed
>
>

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <(E-Mail Removed)>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

Hi John,

I would have thought Word field results that are accurate to 13 decimal
places would be sufficiently precise for most people...

I do agree, though, that Excel is a better tool for the job.

Cheers


"John McGhie [MVP - Word and Word Macintosh]" <(E-Mail Removed)> wrote in
message news:C03BA61C.31975%(E-Mail Removed)...
> Hi Ed:
>
> It "could", but it's not safe to use it like this. Word's math functions
do
> not have sufficient precision to calculate amortisation accurately.
>
> Use Excel: it's made for the job. You can automatically insert the
results
> Excel produces into your Word document.
>
> Cheers
>
>
> On 2/3/06 1:48 AM, in article (E-Mail Removed), "Ed"
> <ed_millis@NO_SPAM.yahoo.com> wrote:
>
> > I've Googled the newsgroups and the knowledge base, and can't find
anything
> > on this. Is it possible to set up a loan calculator with Word's limited
> > math functions?
> >
> > Ed
> >
> >
>
> --
>
> Please reply to the newsgroup to maintain the thread. Please do not email
> me unless I ask you to.
>
> John McGhie <(E-Mail Removed)>
> Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
> Sydney, Australia +61 (0) 4 1209 1410
>

Hi Macropod:

I don't know where you got "13 decimal places" from (I was trying to find
the limit myself when I answered the question...)

I thought that internally they were 32-bit signed floats, which would yield
a precision of nine "digits", not decimal places. That's a bit tight for
loan calculations in dollars and percentages over 20 years.

But, I couldn't immediately lay my hands on the definitive answer.

Cheers


On 17/3/06 11:40 PM, in article (E-Mail Removed), "macropod"
<(E-Mail Removed)> wrote:

> Hi John,
>
> I would have thought Word field results that are accurate to 13 decimal
> places would be sufficiently precise for most people...
>
> I do agree, though, that Excel is a better tool for the job.
>
> Cheers
>
>
> "John McGhie [MVP - Word and Word Macintosh]" <(E-Mail Removed)> wrote in
> message news:C03BA61C.31975%(E-Mail Removed)...
>> Hi Ed:
>>
>> It "could", but it's not safe to use it like this. Word's math functions
> do
>> not have sufficient precision to calculate amortisation accurately.
>>
>> Use Excel: it's made for the job. You can automatically insert the
> results
>> Excel produces into your Word document.
>>
>> Cheers
>>
>>
>> On 2/3/06 1:48 AM, in article (E-Mail Removed), "Ed"
>> <ed_millis@NO_SPAM.yahoo.com> wrote:
>>
>>> I've Googled the newsgroups and the knowledge base, and can't find
> anything
>>> on this. Is it possible to set up a loan calculator with Word's limited
>>> math functions?
>>>
>>> Ed
>>>
>>>
>>
>> --
>>
>> Please reply to the newsgroup to maintain the thread. Please do not email
>> me unless I ask you to.
>>
>> John McGhie <(E-Mail Removed)>
>> Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
>> Sydney, Australia +61 (0) 4 1209 1410
>>
>
>

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <(E-Mail Removed)>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

Hi John,

I was able to establish the limit when developing my Word Field Maths
'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
by comparing the results returned for logarithm calculations to known
values, I was able to establish Word's ability to return calculation results
that were accurate to 13 decimal places. Since the method I used means the
exponent is calculated separately from the mantissa, this is often better
than other methods that might only be accurate to, say, 15 significant
digits.

Cheers


"John McGhie [MVP - Word and Word Macintosh]" <(E-Mail Removed)> wrote in
message news:C041D409.322CD%(E-Mail Removed)...
> Hi Macropod:
>
> I don't know where you got "13 decimal places" from (I was trying to find
> the limit myself when I answered the question...)
>
> I thought that internally they were 32-bit signed floats, which would
yield
> a precision of nine "digits", not decimal places. That's a bit tight for
> loan calculations in dollars and percentages over 20 years.
>
> But, I couldn't immediately lay my hands on the definitive answer.
>
> Cheers
>
>
> On 17/3/06 11:40 PM, in article (E-Mail Removed), "macropod"
> <(E-Mail Removed)> wrote:
>
> > Hi John,
> >
> > I would have thought Word field results that are accurate to 13 decimal
> > places would be sufficiently precise for most people...
> >
> > I do agree, though, that Excel is a better tool for the job.
> >
> > Cheers
> >
> >
> > "John McGhie [MVP - Word and Word Macintosh]" <(E-Mail Removed)> wrote
in
> > message news:C03BA61C.31975%(E-Mail Removed)...
> >> Hi Ed:
> >>
> >> It "could", but it's not safe to use it like this. Word's math
functions
> > do
> >> not have sufficient precision to calculate amortisation accurately.
> >>
> >> Use Excel: it's made for the job. You can automatically insert the
> > results
> >> Excel produces into your Word document.
> >>
> >> Cheers
> >>
> >>
> >> On 2/3/06 1:48 AM, in article (E-Mail Removed),
"Ed"
> >> <ed_millis@NO_SPAM.yahoo.com> wrote:
> >>
> >>> I've Googled the newsgroups and the knowledge base, and can't find
> > anything
> >>> on this. Is it possible to set up a loan calculator with Word's
limited
> >>> math functions?
> >>>
> >>> Ed
> >>>
> >>>
> >>
> >> --
> >>
> >> Please reply to the newsgroup to maintain the thread. Please do not
email
> >> me unless I ask you to.
> >>
> >> John McGhie <(E-Mail Removed)>
> >> Microsoft MVP, Word and Word for Macintosh. Consultant Technical
Writer
> >> Sydney, Australia +61 (0) 4 1209 1410
> >>
> >
> >
>
> --
>
> Please reply to the newsgroup to maintain the thread. Please do not email
> me unless I ask you to.
>
> John McGhie <(E-Mail Removed)>
> Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
> Sydney, Australia +61 (0) 4 1209 1410
>