google sheets reference cell static code example

Example: google sheets reference cell static

A1 is a reference relative to the current cell. 
$A$1 is a static reference to a specific cell.