0
What can you assign to a cell so that Excel will calculate the result?
Wiki User
∙ 8y ago
A formula. All formulas must start with the equals sign. You can also use functions. As an example, when you open the Microsoft Excel and you type up the numbers you want to calculate, you can select the cells that contain the numbers. After doing this, go to the toolbar and press 'Formulas'. There will be an option called 'AutoSum'. Press that and you'll see a subheading called 'Sum' with the sigma, which is similar to "E". The total will appear on the next cell available. Like this you can average numbers and you can identify the minimum and maximum number in your list. You can also choose other functions.
Wiki User
∙ 8y ago
Wiki User
∙ 13y agoAs a general rule, a formula can refer to any cell on the spreadsheet except the cell that the formula is in. So if you are typing a formula into cell B10, then the formula cannot use B10 as part of the formula, but it can use any other cell. With more complex spreadsheets a formula cannot refer to another formula that refers to the cell of the original formula. So a formula in B10 could not refer to another cell that has a formula that uses B10 as part of its formula. Any of these situations are known as circular references and are not allowed in a spreadsheet. So the broader rule is that a formula cannot refer to the cell it is in itself either directly or indirectly through other formulas.
Add your answer:
Earn +20 pts
Mathematical equation assigned to a cell that Excel uses to calculate a result?
formula
What would be the EXCEL formula to calculate 15 percent of 6058.82?
15 / 6058.82 = 0.00247572959751238690041955364246. Formatting the cell for percentages will yield a result of 0.25%
A calculation used in excell?
Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.
In Excel what can be assigned to a cell that will display a calculated result?
formula
In Excel a what-if analysis in a cell containing the desired result called?
For one individual cell, it can be a Goal Seek.
Does Microsoft Excel perform calculations on the data in worsheet and displays the result in a cell?
Yes it does.
Describe the division function in Excel?
If you want Excel to divide one number by another, use the "/" character. For example, if I want to divide 4 by 2 this is what I would enter in a cell: =4/2 Excel will display the result of the division. In this case, 2. You can also divide using cell references. Lets say cell A1 contains the number 4 and A2 contains the number 2. Enter the following in the cell where you want the result: =A1/A2 Again, Excel will display the result (2) in the cell where you entered the formula.
How do you display a symbol in front of a field result in excel?
You can display the currency symbol in front of a result in a cell by formatting the cell for currency. When you format the cell, you can choose the currency symbol you want to display.
In Excel To assign a dollar sign to appear immediately to the left of the first digit with no spaces?
Format the cell(s) as currency and ensure the currency is set to dollars
What is the name of the Excel feature that recalculates formulas every time you enter a value into a cell?
auto-calculate
What is the cell address of the last cell of the Microsoft Excel 2003?
The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.
Do equals G15 do any assign in Excel?
Putting =G15 into any cell on a worksheet, will display the contents of cell G15. If you put it into G15 itself, then you will get what is known as a circular reference error, as the cell is referring back to itself which cannot be done.
