Forum Discussion

abdulrazzaq1968's avatar
abdulrazzaq1968
Copper Contributor
Dec 15, 2021
Solved

how to make cell ranges static

I want to make range static for all cells in a column. For example I want to calculate c1=b1/max(b1:b10) and then c2=b2/max(b1:b10). In this I want to keep max(b1:b10) unchanged for all cells in colu...
Formulas and Functions
  • tauqeeracma's avatar
    tauqeeracma
    Dec 15, 2021

    Hi abdulrazzaq1968 

     

    You can freeze cell range by wrapping them with $. Paste the below formula in C2.

     

    C1=B1/MAX($B$1:$B$10)

     

    Thanks

    Tauqeer

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Dec 15, 2021

Hi abdulrazzaq1968 

 

You can freeze cell range by wrapping them with $. Paste the below formula in C2.

 

C1=B1/MAX($B$1:$B$10)

 

Thanks

Tauqeer

  • abdulrazzaq1968's avatar
    abdulrazzaq1968
    Copper Contributor
    Dec 15, 2021

    tauqeeracma thanks a lot. Your suggested solution solved my problem.

Resources