View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cristin Cristin is offline
external usenet poster
 
Posts: 2
Default 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