ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   V (https://www.excelbanter.com/excel-discussion-misc-queries/29058-v.html)

Air Lancer

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

JE McGimpsey

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


B. R.Ramachandran

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



All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com