+ Reply to Thread
Results 1 to 4 of 4

Formulae to calculate percentage spent from budget

  1. #1
    Registered User
    Join Date
    03-14-2016
    Location
    namibia
    MS-Off Ver
    version 10
    Posts
    14

    Formulae to calculate percentage spent from budget

    Hello Team,

    I am a bit baffled by the formulae I am using to calculate %age spent. I am getting the same %age for actual spending against no budget and also where there is no spending against a set budget? My formulae wrong? See attached excel spreadsheet depicting my cry!


    Many thanks for the correction.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,270

    Re: Formulae to calculate percentage spent from budget

    Because you have no budget in B5, the result of C5/B5 is a #DIV/0 error. Your formula is wrapped in an IFERROR check which tells Excel to give a value of 0 if there is an error, so that's why you get the same result (0) in E5 and E6. Try this instead (in E3, dragged down):
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    03-14-2016
    Location
    namibia
    MS-Off Ver
    version 10
    Posts
    14

    Re: Formulae to calculate percentage spent from budget

    Thank you very much Aargispook, advise and lesson well taken! Am happy to always learn.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,270

    Re: Formulae to calculate percentage spent from budget

    You're welcome, glad I could help and thanks for marking the thread as Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula for creating a bid amount based on money spent out of a budget
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 02-06-2015, 12:13 PM
  2. need function to calculate time spent on the given task
    By Giri.hb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2015, 04:44 AM
  3. [SOLVED] Calculate money Spent between two dates??!!!
    By Copperspaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2013, 05:53 PM
  4. calculate the hours spent for each status
    By Rose Mendoza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2012, 09:35 PM
  5. Budget allocation: Find out how much can be spent based on other columns
    By hojo79 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2012, 06:31 PM
  6. How to compare budget vs. spent pivot table
    By ramseyprescott in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-07-2010, 08:52 PM
  7. [SOLVED] Formulas calculate specified percentage of annual budget in Excel
    By KC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2006, 12:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1