LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Programming Questions


Hermione wrote:
my problem is when I calculate: 10e100 - 1 the answer is 10e100, the
problem is with the degree of precision, and I don't know how to resolve this


Hello Hermione,

You can do that with the xlpSUBTRACT function in my Excel add-in,
xlPrecision 2.0. For example:

=xlpSUBTRACT("10E+100",1)

This returns the correct answer, which is 100 nines:

99999999999999999999999999999999999999999999999999 99999999999999999999999999999999999999999999999999

You can download the free edition of xlPrecision here, and use it as
long as you wish:

http://PrecisionCalc.com


Good Luck,

Greg Lovern
http://PrecisionCalc.com
Get Your Numbers Right

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Answers to questions posing more questions in a workbook sbelle1 Excel Worksheet Functions 2 August 8th 09 01:02 AM
View Questions and Answer to questions I created Roibn Taylor Excel Discussion (Misc queries) 4 July 24th 08 12:05 AM
programming ernie Excel Discussion (Misc queries) 4 March 13th 06 02:06 PM
Please help with programming RandyJ Excel Programming 2 October 8th 04 10:59 PM
Programming in VB Kamyk Excel Programming 2 July 8th 04 11:02 PM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"