I am trying to build a formula on an excel spreadsheet?

What i am trying to do is track % based on the dollar amounts of the sheet. For example;
My budget is 1000.00 and I have paid out 590 I want a cell to show me what percentage I have to completion within a range of 0%-100%

Any assistance would be helpful

Answer:
Assuming budget is in A1 and paid out is in A2.

=1-(A2/A1)

Format cell as percent.
This formula will show you the percentage of the budget used so far. If the figure is overbudget, it will say "Overbudget."
In Cell B4, enter 590 (your costs so far)
In Cell B7, enter 1000 (your budget)

Then type this formula in a cell somewhere:
=IF(B4<=B7,B4/B7,"Overbudget")

PS Don't forget to format this cell as a percentage "%"

See if this works for you.
Cheers

The answers post by the user, for information only, BAnswer.com does not guarantee the right.

Other Questions and Answers:
  • has anyone had any luck with the book"free money to change your life." mathew lesco? is it lagit?
  • in india battery operator bike &SCOOTER?
  • Are there any mentors that are willing to teach me about online stores without scripts?
  • Do you know anyone named josh?
  • Names for a New Company?
  • how to start a home based home made dog treats then start to sell them on line?
  • Can I use 'blank' first-class stamps?
  • help.. regarding my employee?