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
=(B2-A2)*-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 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
|