what is the excel formula for subtraction

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. For all calculations, you always start with =, so the cell knows that here there is a calculation, contrary e.g. 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.

What is the excel formula for subtraction