Here you should be aware that dividing with zero is not allowed, so the cell will display an error message, if the denominator value is zero: If no value has been entered in cell B2 and B3, the value is set to zero. If you want cell B1 to calculate the value of cell B2 divided by cell B3, you write =B2/B3 in cell B1. If you need to divide two or more cells, or divide a value with a cell value, you do it like the 10/2. You can do basic calculations like 1072 without any problems, though it would be more convenient to do this on a calculator, by writing =10/2 in a cell and press enter, and the cell will show the value 5. For all calculations, you always start with =, so the cell knows that here there is a calculation, contrary e.g. When dividing in spreadsheets, the symbol / is used. If you want cell B1 to calculate the value of cell B2 times cell B3, you write =B2*B3 in cell B1. If you need to multiply two or more cells, or multiply a value with a cell, you do it like the 10*2.
You can do basic calculations like 10*2 without any problems, though it would be more convenient to do this on a calculator, by writing =10*2 in a cell and press enter, and the cell will show the value 20. When multiplying in spreadsheets, the symbol * is used. If you want cell B1 to calculate the value of cell B2 minus cell B3, you write =B2-B3 in cell B1. If you need to subtract two or more cells, or subtract a value from a cell value, you do it like the 10-2. You can do basic calculations like 10-2 without any problems, though it would be more convenient to do this on a calculator, by writing =10-2 in a cell and press enter, and the cell will show the value 8. When subtracting in spreadsheets, the symbol - is used.
If an invalid value is entered in a cell, used for the calculations, a note will appear in B1, that a cell value is invalid. If no value has been entered in cell B2 and B3, the value is set to zero:Īs soon as there is a valid value in one of the cells, the content in B1 is updated: If you want cell B1 to calculate the value of cell B2 plus cell B3, you write =B2+B3 in cell B1.
If you need to add two or more cells, or add a value to a cell value, you do it like the 10+2. You can do basic calculations like 10+2 without any problems, though it would be more convenient to do this on a calculator, by writing =10+2 in a cell and press enter, and the cell will show the value 12. When adding in spreadsheets, the symbol + is used.
0 kommentar(er)
