0
In Microsoft Excel which formula will yield a value of 10 5x2 5x2.5 plus 5 51.5 (10052).25?
Wiki User
∙ 6y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?
'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '
What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
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 are constants for in Excel?
Constants are fixed values, so they never change. They are used in formulas where you know a particular value does not change. If you have a formula that is always going to multiply something by 2, then the 2 is a fixed value and can be entered into the formula as a constant, while the other value will be a cell reference, so it can have a variable value, like in the following formula. =H5 * 2
In excel A vertical axis of a chart is called the what?
VALUE
How does value paste in Microsoft Excel?
Normally when you copy and paste, the formula is pasted. If you do a Paste Value, it pastes the result of the copied formula rather than the formula itself.
A 1 in Microsoft Excel is?
A 1 in Microsoft Excel is a value. A1 is a cell in column A and row 1.
'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?
'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '
What is value seek in Excel?
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
What is the formula for PVIFA in Excel?
The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.
How do you calculate RMS value using Microsoft Excel?
You can use the correlation coefficient to calculate the RMSE value using the Microsoft Excel. The correlation coefficient is used to establish the relationship between the values in question.
What function in Microsoft Excel determines most frequent value?
The MODE function.
In Microsoft Excel what automatically resizes the column to fit the width of the columns contents?
In Microsoft Excel, double-click on the line that separates the column labels (the letters at the top of the spreadsheet). The column will resize to fit the contents of the widest value in that column. This usually works unless the contents of the cell are the result of a formula.
What does this formula do equals D2-F4 plus E8D1 in Microsoft Excel?
The formula does the following, it takes value in cell D2 subtracts it from the value in cell F4 and then adds the values in cell E8 and D1.
What part of the Excel user interface displays the value or formula contained in the active cell and allows you to edit that value or formula?
The Formula Bar.
How do you make Microsoft Excel enter the greater value when choosing between a calculation and a set value for a formula?
You can use the MAX function. You could have the formula generating the value you want to test in one cell and then you the MAX function to choose between it and the fixed value. You could also have the formula generating the value built into the MAX. Say your generating formula is A2+B2 and is in cell C2 and your fixed value is 20, you could do this: =MAX(C2,20) You could also just put the formula into the MAX like this: =MAX(A2+B2,20)
What is v - look up?
VLOOKUP is a function of Microsoft Excel. You can use VLOOKUP to find a value in a table or list on an Excel sheet. It looks at a value in a column and finds the corresponding value in another column in the same row.
