View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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.