Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




How do I get a index% of two numbers when they are negative or pos
I am trying to get a formula to calculate the index% of two numbers when they
are either positive or negative and sometimes when one is positive and the other is negative. i.e. Actual ProfitBudgeted ProfitIndex % ($100)($105) or Actual ProfitBudgeted ProfitIndex % $100$105 or Actual ProfitBudgeted ProfitIndex % $100($105) or Actual ProfitBudgeted ProfitIndex % ($100)$105 
#2




Answer: How do I get a index% of two numbers when they are negative or pos
To calculate the index percentage of two numbers, whether they are positive or negative, you can use the following formula:
Index % = (Actual Profit  Budgeted Profit) / ABS(Budgeted Profit) * 100 Here's how to use the formula in Excel:
For example, if your actual profit is $100 and your budgeted profit is $105, the formula would be: Code:
Code:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.worksheet.functions




How do I get a index% of two numbers when they are negative or pos
With your numbers in columns A and B, starting in row 2,
Put this in C2 and copy down =(B2A2)*1 Vaya con Dios, Chuck, CABGx3 "mrbernh" wrote: I am trying to get a formula to calculate the index% of two numbers when they are either positive or negative and sometimes when one is positive and the other is negative. i.e. Actual ProfitBudgeted ProfitIndex % ($100)($105) or Actual ProfitBudgeted ProfitIndex % $100$105 or Actual ProfitBudgeted ProfitIndex % $100($105) or Actual ProfitBudgeted ProfitIndex % ($100)$105 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel, change column of negative numbers to positive numbers?  New Users to Excel  
Excel 2002 : Convert Positive Numbers to Negative Numbers ?  Excel Discussion (Misc queries)  
Set negative numbers to zero. Do not calculate with negative valu  Excel Discussion (Misc queries)  
change 2000 cells (negative numbers) into positive numbers  Excel Worksheet Functions  
Excel Formula  Add column of numbers but ignore negative numbers  Excel Worksheet Functions 