I am tallying up end numbers in a budget. How do I get Excel to show the proper percentage spent if someone has spent over budget?
For example,
There was no money forecasted for a purchase, so this has been set to $1 for budget calculations. There was actually money spent for that category- i.e $5597.50 =thus the Year to date spending percentage shows as -559650.00%. This is not helpful for future predictions since it is such a large percentage. Can anyone help?
For example,
There was no money forecasted for a purchase, so this has been set to $1 for budget calculations. There was actually money spent for that category- i.e $5597.50 =thus the Year to date spending percentage shows as -559650.00%. This is not helpful for future predictions since it is such a large percentage. Can anyone help?