| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
