Hello!
Need help with the following case:
I have a row with numbers 50 23 45 33 26 56 22, for example.
They are in Cells A1:G1. To calculate the maximum difference between two consecutive cells I use the following array formula:
=MAX(ABS(B1:G1-A1:F1))
In this case the max difference is 34, it's the difference between 22 and 56 in cells G1 and F1. However, I need to get this max difference in percent, what will be -155%
The question is, is there any formula so I could get the value in percent immediately?
Bookmarks