Forum Discussion

Copper Contributor

Jun 07, 2019

Solved

Advanced formula to show number movement

Hi, I am looking for a formula to represent the difference between digit movement, the lowest difference would be 0 and the highest 5 the result would be taken from 2 columns eg. A B 7 16 =...

excel

Formulas and Functions

Twifoo
Jun 07, 2019
You may try this formula:
=MIN(ABS(RIGHT(A2)-RIGHT(B2)),
RIGHT(A2)+10-RIGHT(B2),
RIGHT(B2)+10-RIGHT(A2),
5)

Twifoo

Silver Contributor

Jun 07, 2019

You may try this formula:
=MIN(ABS(RIGHT(A2)-RIGHT(B2)),
RIGHT(A2)+10-RIGHT(B2),
RIGHT(B2)+10-RIGHT(A2),
5)

Peter1550

Copper Contributor

Jun 07, 2019

Twifoo

Hi Twifoo,

Thanks for your replay this formula works! but how to modify it so it automatically applies to all desired cells for example and columns?

Thanks