MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

======

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.

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

Thanks Aladin

Thanks

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

Yes. Thanks. [NT]

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

Re: Small business accounting using Microsoft Excel

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!

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

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

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.