How do you calculate formulas in Excel 2007?

5 pts.
Tags:
Excel 2007
Microsoft Excel formulas
I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a  240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for 2010 will then be $90,000. I would like a formula that would then calculate the balance to be billed in 2011.  Can you help me figure out a formula that will do this based on the start date of 4/1/2010.

Software/Hardware used:
Excel 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

=240000-90000
OR
=240000-A1-B1-C1-D1 and so on where A1, B1, … are the cells for each month in 2010.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    If the start date (in cell A1 for this example) is going to be different for each contract, you could use a formula like this:
    =240000-(10000*(12-MONTH(A1)+1))
    Also, you could put 240,000 and 10,000 in cells and parameterize the above formula.
    70,200 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following