The four types of arithmetic, addition, subtraction, multiplication and division, are basic skills that both users and spread sheets have to be able to understand and work with. So, in order to ensure the educational material on this site also covers this, we will take a look at four very similar examples, to see the similarities and differences when using the four types of arithmetic, when used in the two office suites covered by the site.

When adding in spreadsheets, the symbol + is used. For all calculations, you always start with =, so the cell knows that here there is a calculation, contrary e.g. to a date or a text string.

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. If you need to add two or more cells, or add a value to a cell value, you do it like the 10+2. If you want cell B1 to calculate the value of cell B2 plus cell B3, you write =B2+B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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.

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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. If you need to add two or more cells, or add a value to a cell value, you do it like the 10+2. If you want cell B1 to calculate the value of cell B2 plus cell B3, you write =B2+B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero:

For

For

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For

For

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.

For

For

When subtracting in spreadsheets, the symbol - is used. For all calculations, you always start with =, so the cell knows that here there is a calculation, contrary e.g. to a date or a text string.

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. If you need to subtract two or more cells, or subtract a value from a cell value, you do it like the 10-2. If you want cell B1 to calculate the value of cell B2 minus cell B3, you write =B2-B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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.

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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. If you need to subtract two or more cells, or subtract a value from a cell value, you do it like the 10-2. If you want cell B1 to calculate the value of cell B2 minus cell B3, you write =B2-B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero:

For

For

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For

For

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.

For

For

When multiplying in spreadsheets, the symbol * is used. For all calculations, you always start with =, so the cell knows that here there is a calculation, contrary e.g. to a date or a text string.

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. If you need to multiply two or more cells, or multiply a value with a cell, you do it like the 10*2. If you want cell B1 to calculate the value of cell B2 times cell B3, you write =B2*B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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.

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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. If you need to multiply two or more cells, or multiply a value with a cell, you do it like the 10*2. If you want cell B1 to calculate the value of cell B2 times cell B3, you write =B2*B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero:

For

For

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For

For

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.

For

For

When dividing in spreadsheets, the symbol / is used. For all calculations, you always start with =, so the cell knows that here there is a calculation, contrary e.g. to a date or a text string.

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. If you need to divide two or more cells, or divide a value with a cell value, you do it like the 10/2. If you want cell B1 to calculate the value of cell B2 divided by cell B3, you write =B2/B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero. 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:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

If an invalid value, other than zero in the denominator, is entered in a cell, used for the calculations, a note will appear in B1, that a cell value is invalid.

For**Microsoft Excel** it looks like this:

For**OpenOffice Calc** it looks like this:

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. If you need to divide two or more cells, or divide a value with a cell value, you do it like the 10/2. If you want cell B1 to calculate the value of cell B2 divided by cell B3, you write =B2/B3 in cell B1.

If no value has been entered in cell B2 and B3, the value is set to zero. 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:

For

For

As soon as there is a valid value in one of the cells, the content in B1 is updated:

For

For

If an invalid value, other than zero in the denominator, is entered in a cell, used for the calculations, a note will appear in B1, that a cell value is invalid.

For

For