Timmypg Posted January 13, 2009 Share Posted January 13, 2009 I'm trying to make my own checkbook with Excel. I have it all setup nice but here is where I'm stuck. I can get it to add my credits to to my total but I can't get it to subtract my debits. I know there must be a formula but I'm not good with computers. Also, I'm using a Mac if that matters. TIA Quote Link to comment Share on other sites More sharing options...
CaP'N GRuNGe Posted January 13, 2009 Share Posted January 13, 2009 I'm trying to make my own checkbook with Excel. I have it all setup nice but here is where I'm stuck. I can get it to add my credits to to my total but I can't get it to subtract my debits. I know there must be a formula but I'm not good with computers. Also, I'm using a Mac if that matters. TIA Just enter your debits as negative numbers and use the sum function. Quote Link to comment Share on other sites More sharing options...
Timmypg Posted January 13, 2009 Author Share Posted January 13, 2009 I can try that but right now I have everything in different columns. Quote Link to comment Share on other sites More sharing options...
CaP'N GRuNGe Posted January 13, 2009 Share Posted January 13, 2009 =sum(a1:a10)-sum(b1:b10) Quote Link to comment Share on other sites More sharing options...
Timmypg Posted January 14, 2009 Author Share Posted January 14, 2009 Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.