PC Review


Reply
Thread Tools Rate Thread

Calculate plus or minus

 
 
Joel
Guest
Posts: n/a
 
      14th Dec 2007
Hi quick question if you would please

I have a spreadsheet withe 4 columns. Column 1 Balance plus what I have paid
with the following formula:

=IF(Template!R29="","",(J6-Template!R29)) This take my Credit card Balance
and deducts what I have paid off it this month

Column two is a new column Full amount plus amount used again with the
following formula:

Column three Amount of monthly interest with the following formula:

This adds on my monthly interest that gets added on every month.

The final column four balance carried forward it has the following formula:

=IF(D7="","",(D7+H7))

This adds the the balance paid plus the interested added what I would like
it o do is all subtract what I have sent on the card and include that in tha
balance carried forward.

Thanks in advance Joel



=IF(Template!T29="","",(J6+Template!T29))


=IF(D7="","",(D7+H7))

What I would like it to do is add those cells but I would like to subtract
as wellI have a cell that as the following formula

=IF(Template!T29="","",(J6+Template!T29))


--
N/A
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Difference between 2 tables Plus/Minus 10% Hatman50 Microsoft Access Queries 8 23rd Jun 2010 02:05 PM
how do i calculate the difference plus or minus between two numbe. Steve Paton Microsoft Excel Worksheet Functions 2 6th Oct 2008 08:27 PM
calculate minus figures =?Utf-8?B?TmlnZWw=?= Microsoft Excel Misc 1 30th Mar 2005 04:33 PM
calculate minus figures only =?Utf-8?B?TmlnZWw=?= Microsoft Excel Misc 2 30th Mar 2005 12:03 PM
Calculate minus figures only =?Utf-8?B?TmlnZWw=?= Microsoft Excel Misc 0 30th Mar 2005 10:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:39 PM.