Select G10. Enter "L" (without quotes) in the Name box at the left of
the Formula Bar.


In article ,
"Air Lancer" <chesserhawk-email.yahoo.com.sg wrote:

How do you assign a symbol/name to a cell?

E.g.

instead of =if(G101,"Yes", "no") , change it as =if(L1,"Yes", "no").