You can calculate quantity in Excel with the SUM function.
Allows Excel to automatically calculate formulas in real time. When a referenced cell changes, the formula automatically updates.
It depends on the formula you choose. If you have autocalculate turned on (default setting) you will not need to do anything after you enter the formula; Excel will calculate automatically any time related cell values change.
It is called creating a formula.
Delete the current formula and then use the Auto Sum to put in the sum formula.
The formula you use depends upon what you are trying to calculate. If you want to multiply two cells (e.g. A1 and C2), the formula would be =A1*C2.
A spreadsheet such as Microsoft Excel or Open Office Calc.
You calculate square root in Excel using the Sqrt() function. for example: If the value of A1 is 81 and A2 contained the formula "=Sqrt(A1)", The number 9 would be displayed.
If auto-calculation is turned on, it will calculate the formula and display the value. If the formula is composed of relative cell addresses, it will adjust the formula cell references relative to the current location.