0
Most formulas in Excel are quite basic, such as formulas for SUM functions. You use them in all sorts of situations, so it is very much a case that you use them when you need them. In that way, there is no specific answer to the question. So you use a basic formula when you need to use one. You would not use a very complicated formula, when a basic one will do.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
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 formula is best for basic math using Microsoft Excel?
There is no single formula that can be said to be the best. Every calculation you do is different and there are different ways in Excel to do the same calculation. It will depend on the calculation you want. So the question cannot really be answered. Generally you can use the plus(+), minus(-), multiply(*) and divide(/) operators in Excel and they would be used in basic mathematical calculations. Functions like SUM can also be used to do some basic calculations.
When more than one arithmetic operator is involved in a formula Excel follows the same basic order of that you use in algebra?
Order of Operations
What is replicating a formula in Excel?
Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.
Which excel formula mostly use for MIS?
vlookup
Can you use a 'wild card' in a formula in Excel?
Yes you can.
When more than one operator is involved in a formula Excel follows a different basic order of operations from that used in algebra.?
Excel will use the standard order of operations according to the laws of mathematics. See the related question below.
Which formula in excel can i use to find the total cost of items?
The "Sum" formula works best.
When more than one arithmetic operator is involved in a formula Excel follows the same basic order of that you use in algebra. a.placement b.operations c.positioning d.selections?
It follows the order of operations.
Is there a shortcut key for fractions?
Not in Excel. Excel does not use fractions. If you need to use fractions, then turn them into decimals. You can represent 1/2 in excel with the formula =1/2.
How do you use the rounded the the nearest hundredth formula?
The formula, in Excel and similar spreadsheets, is "=round(number,2)".
What is the formula for sound on spreadsheet?
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
