# Formulae to calculate percentage spent from budget

1. ## 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.

2. ## 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:
`Please Login or Register  to view this content.`

3. ## Re: Formulae to calculate percentage spent from budget

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

4. ## Re: Formulae to calculate percentage spent from budget

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

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

#### 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