| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function do I use to subtract two cells in the same row?
I set up a balance sheet and want to subtract expenses (col C) from income
(col B). I want the difference to display in col D on a particular line but I can't find a function that will do this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function do I use to subtract two cells in the same row?
One cell in column C subtracted from one cell in column D:
=D2-C2 Everything in column C subtracted from everything in column D: =SUM(D2:D100)-SUM(C2:C100) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mscott" wrote: I set up a balance sheet and want to subtract expenses (col C) from income (col B). I want the difference to display in col D on a particular line but I can't find a function that will do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get my function to subtract .5? | Excel Worksheet Functions | |||
| How do I add a column of cells, but IF a row has (), subtract? | Excel Worksheet Functions | |||
| How can I subtract cells in a row | New Users to Excel | |||
| How do i subtract cells in an IF function? | Excel Worksheet Functions | |||
| how to add or subtract from two cells into one | Excel Worksheet Functions | |||
Linear Mode
