#1   Report Post  
Air Lancer
 
Posts: n/a
Default V

Hi all,

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").




--
Air Lancer
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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").

  #3   Report Post  
B. R.Ramachandran
 
Posts: n/a
Default

Hi,
Insert-Name-Define
B.R.Ramachandran

"Air Lancer" wrote:

Hi all,

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").




--
Air Lancer

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"