Forum Discussion

Randy Tibbits's avatar
Randy Tibbits
Copper Contributor
Jul 16, 2018

Help trying to auto calculate one cell when other cells are populated.

Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Jul 16, 2018

    Hi Randy,

     

    Please try this formula in cell B5:

    =OFFSET(A3,-1,COUNTA(B3:M3))/MAX(B3:M3)

     

    Regards

Randy Tibbits's avatar
Randy Tibbits
Copper Contributor
Jul 16, 2018

I need to automatically calculate a value in one cell (i.e B5) when the value of other cells are updated

the formula I am currently using is SPI(B5)=f2/MAX(b3:m3)

 

F2 is the month of May, so when I receive the info for the month of June which will be G2, I would like the SPI value to auto calculate with out having to update the formula.

 

Hope this makes sense.

Resources