0
How you can give formula in a cell excel in which text is already there?
NehulJain
If you have a cell the currently holds the text "friends," and you want it to combine a foumula and text in the same cell, here's an example:
In cell A1 enter 23 (the number of friends you have).
In cell A2 enter the following formula:
="You have " & A1 "friends."
[You have 23 friends.]
When you change the number in A1, you will see the number change in A2.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Excel last cell in a column with an amount in it?
Use 'COUNTA' function. for example: if you want to know the last cell of column B, use the formula below =COUNTA(B:B) It'll give you the cell reference If you want to know the value then use formula below =INDIRECT("B"&COUNTA(B:B))
What is subtotal percentage formula field?
Are you asking about something in Excel? Can you give example?
Which formula correctly instructs Excel to add all values in cells B8 through B11?
To sum a range use the formula =Sum(first cell:last cell) So in the exaple you give it would be =SUM(B8:B11)
Can you use a letter in an Excel cell to represent a number value?
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.
Can you use a named range instead of a cell address in a formula in excel?
Yes you can. A name can be applied to a single cell or to a range of cells. Naming a cell can be handier than trying to find or remember the address of a cell. That could give you a formula like: =Total_Sales * Tax_Rate This is obviously easier to understand and although it takes more keystrokes to type than an address would, the user does not have to remember the cell addresses used.
What on the computer allows you to solve complex problems where a number of variables can be changed in a worksheet in order to meet a goal in a particular cell?
In a spreadsheet software such as Microsoft Excel or OpenOffice Calc, there is a Goal Seek tool (Under Data, What If Analysis for Excel; under Tools for OpenOffice), which allows you to try to find a value of a particular cell, which will give the desired value in a target cell. The target cell needs to contain a formula, whose value changes with the cell that you are adjusting.
What is a cell's functions?
Cell function is to produce lipid compounds and to breakdown glucose to CO2 and H2O.
How do you give condition in ms - excel to find pass or fail?
You would use the IF function. Suppose the mark you want to check is in cell B2 as a percentage. Say the pass mark is 40%. Then in another cell you could have this formula: =IF(B2>=40%,"Pass","Fail") In the cell it will then display either the word Pass or Fail.
What is circular reference for Microsoft Excel?
A formula cannot refer to the cell it is in. If it does, it is a circular reference. If you put =A4+5 into cell A4, then the formula is telling it to add 5 to the total in the cell. That will give a new total, which is then being asked to add 5 to itself, giving a new total, which is then being asked to add 5 to itself and that would go on forever. It is not possible to get an answer. It will go around forever, like a circle, hence the name. So a formula can not directly or indirectly refer to the cell it is in.
Is there a way to write the equation 6 to the second power with excel?
Yes. Use shift+6, (^) for to the power. So "=6 shift+6 2" will give you "=6^2" in the formula bar and the cell should show 36.
What is the formula for writing yes in Excel 2003?
No formula is needed. You can just type Yes into a cell. You would only have a formula if you have something like a condition to check to give you yes or no. You could use an IF function for that. If an exam score was in A2 and the pass mark for an exam was 40% and you wanted to say Yes if someone passed or No if they failed, your formula could be:=IF(A2>=40%,"Yes","No")
What does the ROW function do in Excel?
It gives you the row part of a cell reference. =ROW(D3) This will give the value 3, as that is the row part of the cell reference.
