How do I get a index% of two numbers when they are negative or pos

[mrbernh]

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 Profit-------Budgeted Profit------Index %
($100)--------------($105)
or
Actual Profit-------Budgeted Profit------Index %
$100-----------------$105
or
Actual Profit-------Budgeted Profit------Index %
$100--------------($105)
or
Actual Profit-------Budgeted Profit------Index %
($100)--------------$105

 

[CLR]

With your numbers in columns A and B, starting in row 2,

Put this in C2 and copy down
=(B2-A2)*-1

Vaya con Dios,
Chuck, CABGx3