View Single Post
  #1  
Old March 16th, 2010, 04:29 PM posted to microsoft.public.excel.worksheet.functions
dz
external usenet poster
 
Posts: 69
Default calculating % of a monthly budget on a daily basis

I have a monthly budget figure, and I'm trying to use a formula to show what
% of budget I'm at on a daily basis. For instance, my budget for the month is
that I'll make 800 items, and halfway through the month if my actuals show
I've made 400 items, I want the % of budget column to show 100%, not 50%.
How do I do this? Thanks in advance for your help.