| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to calculate percentage with some variables
Hello,
I'm trying to calculate the % of YTD Actual # compared to the Annual budget #. In some cases it's easy: YTD Actual = $10,000, Annual budget = $20,000, so 10000/20000 = 0.5 (formatted to a percentage = 50%) However, in cases where we budgeted a loss, but have actually seen a profit, i'm stumped: YTD Actual = $12,000, Annual budget = <$9,000: WHAT IS THE FORMULA FOR THIS? Any help is much appreciated. -- Cristin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate maximum with variables. | Excel Worksheet Functions | |||
| Nesting IF/calculate percentage | Excel Worksheet Functions | |||
| How do I calculate an average by a certain percentage? | Excel Worksheet Functions | |||
| calculate percentage | Excel Worksheet Functions | |||
| Is there an easy way calculate 2 variables in conditional sum wiz. | Excel Worksheet Functions | |||
Threaded Mode
