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

JKPieterse's avatar
JKPieterse
Silver Contributor
Jul 16, 2018
Please state your question in plain text in the message, rather than in a screen-shot. This ensures other people may find your question and potential answers to it.

Resources