| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need a formula that calculates current age on a daily basis? | Excel Discussion (Misc queries) | |||
| HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
| Total OVT on monthly basis | Excel Worksheet Functions | |||
| Calculating monthly budget expenses | Excel Worksheet Functions | |||
| Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions | |||
Threaded Mode
