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