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" wrote in message
...
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" wrote in message
...
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 , "Ed"
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
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]" wrote in
message ...
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 , "Ed"
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
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 , "macropod"
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]" wrote in
message ...
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 , "Ed"
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
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
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]" wrote in
message ...
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 , "macropod"
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]" wrote
in
message ...
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 ,
"Ed"
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
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
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410