Ask Your Question

Search criteria has 9E+100. What does it mean

asked 2019-11-29 00:05:15 +0100

Jerome gravatar image

In spreadsheet the search criteria in a VLOOKUP functions is 9E+100. The column expected to search is E and I would understand E9, but what does 9E+100 mean?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-11-29 01:48:35 +0100

ProLogic gravatar image

updated 2019-11-29 01:56:16 +0100

You can return the last numeric value in a column when you use an extremely large number as the lookup value (to be sure that it will be larger than any number) and 9E+100 is an EXTREMELY LARGE number, it a 9 with 100 zero behind it. Almost a Googol number

=VLOOKUP(9E+100... for numeric to return the last value

I would ad when searching for the last text value a series of "zzzzzzz" will have the same effect for text than 9E+100 for numerics

=VLOOKUP( "zzzzzzz".... for text to return the last value

edit flag offensive delete link more

answered 2019-11-29 00:14:43 +0100

Opaque gravatar image

updated 2019-11-29 00:29:17 +0100


9E+100 is the scientific notation of 9 x 10^100 and that got nothing to do with a cell E9 but a very large number with a leading 9 followed by 100 zeroes ( just like 9 million = 9 000 000 [9 and 6 times a zero] in scientific notation would read 9E+6)

See also Number Format Codes in LibreOffice Help.

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-29 00:05:15 +0100

Seen: 160 times

Last updated: Nov 29 '19