Positive to Negative Percentage TIP !

L

Loxley

To get a %age variance when comparing two columns of data, i have com
up with the following matrix of possible options.

Column G contains the ACTUAL value and Column H the Plan/Budget value

=IF(G15<0,IF(H15<0,IF(G15>H15,((+H15/G15)-1),(-((+G15/H15)-1))),(IF(H15=0,-1,((+G15/H15)-1)))),(IF(H15<0,IF(G15=0,1,((-G15/H15)+1)),IF(H15=0,1,IF(G15=0,-1,G15/H15)))))


=IF(G15<0,IF(H15<0,IF(G15>H15,"Both Negative Actual Improved","Bot
Negative Actual Worse"),(IF(H15=0,"Actual Negative NO Budget","Actua
Negative Budget Pos"))),(IF(H15<0,IF(G15=0,"NO Actual Budge
Negative","Actual Pos Budget Negative"),IF(H15=0,"Actual Pos N
Budget",IF(G15=0,"NO Actual Budget Pos","Actual Pos Budget Pos")))))


Hope this is of some use to someone !

Mar
 
Top