If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculation help please
Hi i am trying to calculate my rent account in an excel worksheet but every
time i enter a sum function to get a running total i get an error? for example i get a charge once a fortnight and say my balance is £600 i want to add the charges every fortnight then take away the payment every month and leave a balance and so on until i am clear or so i tried =sum(balance,+charge,-payment)and hit enter but nothing please help -- jim4abobor2 |
#2
|
|||
|
|||
calculation help please
"james horne" wrote:
=sum(balance,+charge,-payment)and hit enter but nothing First, it will be difficult to offer constructive help without a specific example, with real numbers, real formulas and real cell references. Second, it is unclear what "but nothing" means. That seems different from "get an error". But both descriptions are too vague. If you get an Excel error indication, which one (e.g. #VALUE, #NUM). If you get "erroneous" (unexpected) numbers, what numbers, and what did you expect? Finally, you probably so not need to use the SUM function -- although ironically, that is more likely to mask errors than it would cause them. If the previous balance is in D1, the current charges are in B2, and the current payment is in C2, the current balance in D2 might be: =D1+B2-C2 As you copy the formula down column D, the cell references will update automagically. But that's pretty close to what you have already; so that might not be helpful. Again, please post specifics. ----- original message ----- "james horne" wrote in message ... Hi i am trying to calculate my rent account in an excel worksheet but every time i enter a sum function to get a running total i get an error? for example i get a charge once a fortnight and say my balance is £600 i want to add the charges every fortnight then take away the payment every month and leave a balance and so on until i am clear or so i tried =sum(balance,+charge,-payment)and hit enter but nothing please help -- jim4abobor2 |
Thread Tools | |
Display Modes | |
|
|