Programming Questions
 

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

Programming Questions
 

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

Programming Questions
 

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

Programming Questions
 

For the second question: You can enter a 2 dimensional matrix in Excel
easily, since Excel is laid out in a row & column format. There are a few
Excel functions, also, that perform matrix operations: MDETERM will calculate
the determinant, MINVERSE for the inverse, and MMULT to multiply two matrices
(cross product). You could perform just about any other mathematical
procedure on matrices but would have to calculate each element with formulas
you would build from simpler (scalar) functions and that could get tedious.
--
- K Dales


"Chip Pearson" wrote:

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

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

Programming Questions
 

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