0
Can you use a letter in an Excel cell to represent a number value?
Wiki User
∙ 14y ago
Yes. Excel does not do this directly, but there are several ways to create the effect.
EXAMPLE: You want to write the forumua =A+B and show a result of 10.
- In cell A1, enter 4. Give cell A1 the name "A" (how to do this is another question)
- In cell A2, enter 6. Give cell A2 the name "B"
- In cell A3, enter the formula =A+B and observe that the cell displays 10.
- The reason this works, is because it is the same as =A1+B1 (you just gave the cells different names for Excel to use).
If you ask the question again, with specific information about what you are trying to accomplish, you will get a more useful answer.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Excel recognizes an entry as a value if it is a number or it begins with?
Excel recognizes an entry as a value if it is a number or it begins with one of these symbols: +, -, =, @,#, or $ Rina
What is a number also known as in Excel?
It can be called a value.
A letter used to represent a value?
a variable
In the hexadecimal system what decimal value does the letter A represent?
value of 10
What decimal value does the letter A represent in the hexadecimal system?
Value of 10
How do you format an absolute value in Excel?
In excel cell, type =ABS(XXXX). It will return the absolute value of the number or equation you put within the parentheses.
What does it mean when your value in a chart in excel turns red or has brackets around them?
The value is a negative number.
How can you use absolute value to represent a negative number in a real-world situation?
use a absolute value to represent a negative number in the real world
What is a lookup list in Excel?
It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.
What value does the value 3 represent in the number 23780641?
three million
What letter of the alphabet does the positive absolute value function represent?
Not aware that there is any such letter.
What value does the 3 represent in the 16.344 number?
0.3
