Google-sheets – Subtracting formula in Google Spreadsheet

google sheets

How do I subtract the amount in one cell, from the amount in another cell, in Google Spreadsheets? Do I use a formula to subtract? Can you tell me what is it?

Best Answer

If the first value is in cell A1 and the second is in cell B1, and you want to show the result of the subtraction in cell C1, simply put in cell C1:

=A1-B1

It doesn't matter whether the values in either A1 or B1 were achieved with a simple value or a function.

Of course, your values need to be numbers for this to work.