Forum Discussion
Can't seem to find the answer to a simple solution?
Hello, Looking for a formula to display a changing value to show up in one particular cell: "E" column is a running total. What formula can I use in E10 (for example) to display to ...
HansVogelaar Wow, fantastic!! Thank you!! I have no idea why that works reading the code but it does. Awesome!!
- Hans,
=LOOKUP(9.99999999999999E+307,E2:E9)
Why "+307" in this code?? I am trying to get it to work in a totally different spreadsheet but having trouble getting it to come out right. Is the ...+307... germane only to the example I provided above or is it a universal value that can be used in any column application?
Thanks- Or does the "E" after all the 9's have to match the particular column that I want to use the formula in? Whether in the same spreadsheet or a completely different one?
The E indicates so-called exponential notation.
9.99999999999999E+307 is Excel's notation for 9.99999999999999*10^307.
It is the largest number that you can enter into an Excel cell, i.e. larger than any number you want the formula to return. LOOKUP searches for this number, and since it cannot find it, it returns the last number it found.