Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

9.99999999999999E+307

Posted by Stephen Hoadley on January 30, 2002 7:33 AM

I have seen this in quite a few formulas what does it do please 9.99999999999999E+307 when do you use it

Check out our Excel Resources

Re: 9.99999999999999E+307

Posted by Aladin Akyurek on January 30, 2002 7:40 AM

Stephen --

It's biggest positive number that you can have in Excel.
When you use as a lookup value in MATCH with match-type FALSE (or 0) that looks in a row or column of numeric type, MATCH will return the column or row number of the last numeric value in the row or the column.

Aladin

======

Re: 9.99999999999999E+307

Posted by Juan Pablo G. on January 30, 2002 7:45 AM

I'm sure Aladin meant

>When you use as a lookup value in MATCH with match-type 1 or omitted.

Juan Pablo G.

Thanks Aladin

Posted by Stephen Hoadley on January 30, 2002 7:47 AM

Thanks

Yes. Thanks. [NT]

Posted by Aladin Akyurek on January 30, 2002 7:48 AM

Re: Small business accounting using Microsoft Excel

Posted by Mike on February 03, 2002 4:43 AM

I am new at Microsoft Excel, never used PC book-keeping, always doing it by hand which is proving to be strenuous.

I would like to use Excel for double entries, namely
Journal and Ledger.

Can you show me how to proceed in a layman's
language, indicating which keys I should strike
for each step on my keyboard. I would appreciate
your assistance. Thanks!

Re: Can u help me with printing formulas?????

Posted by Alexandria on March 26, 2002 4:05 PM

Hi,
I'm a bit new here, but I would like to know if u or anyone is able to help me print some formulas in Xcel. What do u go into so that u may view all the formulas on the page????????

Plzzzz Eml me as soon as possible with the answer.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.