excel formula

In what context? If you want to type the letter "t" in a cell and have the value "5" appear somewhere else, there are a number of ways to do it. One might be:

=IF(A1="t",5,"Not 5") If A1 contains t then display 5 otherwise show the word No.
If this isn't what you want, please give more details.

You can use the excel's name a cell feature. For example, in A1, key in 5 and define the name as t.

Then for every formula refers t, it means 5. for example in c1, i make this formala =t+t, the result in c1 would be 10.

Hi, here is the answer:
=======================
1-Activate the "Insert" Menu
2-Choose "Name"
3-Choose "Define..."
4-The "Define Name" dialogue box appears
5-In the "Names in workbook:" box type the
letter "T" or whatever the name you want.6-In the "Refers to:" box type the coressponding
value to the defined name for example "5".

I wish you good luck,,,

This question was auto closed due to inactivity