use =ROW() to get the row number
--
Gary's Student


"ryany" wrote:

For example, I freeze pane for row 1, and want A1 cell to display "Text1"
when windows is scrolling within row 2~100, and display "Text2" when it's
scrolled beyond row 101, can I use such formula in A1:

=if(GetCurrentTopRow() < 100, "Text1", "Text2")

is there such a function?