Forum Discussion

Mike_Schell's avatar
Mike_Schell
Copper Contributor
Jul 16, 2022

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 ...
Formulas and Functions
  • Mike_Schell's avatar
    Mike_Schell
    Copper Contributor
    Jul 17, 2022

    HansVogelaar Wow, fantastic!! Thank you!!  I have no idea why that works reading the code but it does. Awesome!!

     

    • Mike_Schell's avatar
      Mike_Schell
      Copper Contributor
      Jul 17, 2022
      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
      • Mike_Schell's avatar
        Mike_Schell
        Copper Contributor
        Jul 17, 2022
        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?

Resources