In the order of operations exponentiation comes before addition/subtraction,
so 10e100-1 is equal to (10e100) -1; that would naturally round off to
10e100. I am pretty sure what you want is this:
10e(100-1)
Use brackets to force evaluation of the operands in the order you intend.

Dans l'ordre des opérations l'élévation Ã* une puissance vient avant
addition/subtraction, ainsi 10e100-1 est égal (10e100) -1 ; cela arrondirait
naturellement au loin Ã* 10e100. Je suis assez sûr ce que vous voulez est ceci
: 10e(100-1) Utilisez les parenthèses pour forcer l'évaluation des opérandes
dans l'ordre que vous prévoyez.
(Merci a BabelFish, j'espere que la traduction n'est pas trop mal!)
--
- K Dales


"Hermione" wrote:

HI Chip

thanks for your answer
I want to calculate a matrix

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

any idea

Thanks

"Chip Pearson" a écrit :

1- I'd like to know if Excel accept value with type: long
double

No. Excel uses 8-byte double precision numbers.

2 - Can I program a matrix with VBA for Excel

Probably. What do you mean by 'program a matrix'?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Hermione" wrote in message
...
Hi

I have some questions if some body can help me please:

1- I'd like to know if Excel accept value with type: long
double


2 - Can I program a matrix with VBA for Excel

Thanks