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.

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.