ExcelBanter - How to subtract value in one cell from aanother cell value?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to subtract value in one cell from aanother cell value? (https://www.excelbanter.com/excel-worksheet-functions/32438-how-subtract-value-one-cell-aanother-cell-value.html)

freder

How to subtract value in one cell from aanother cell value?

I want to calculate the difference between income and expense by subtracting
one total cell from the other total cell. I don't find any reference to
subtract or minus functions in Excel. HELP

jen

=SUM(A1-A2)

"freder" wrote:

I want to calculate the difference between income and expense by subtracting
one total cell from the other total cell. I don't find any reference to
subtract or minus functions in Excel. HELP

Bob Phillips

=A1-A2

SUM is superfluous here.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"jen" wrote in message
...
=SUM(A1-A2)

"freder" wrote:

I want to calculate the difference between income and expense by
subtracting
one total cell from the other total cell. I don't find any reference to
subtract or minus functions in Excel. HELP

All times are GMT +1. The time now is 04:08 AM.