Sunday, December 6, 2009

EXCEL function to find percentage difference of data match/mismatch(numeric data only)

=IF(L61>J61,100-ABS(((J61-L61)/ABS(L61)))*100,100-ABS(((J61-L61)/ABS(J61)))*100)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)