Hi,
as the tread name say : Please can someone correct my formula? i need to display Low/High Digits on unverse of 10.
Low Digits = 1,2,3,4,5
High Digits = 6,7,8,9,0
Example:
On Column C15 (down) i have the following Digits and on K15 (down) display the output (with my formula)
4-4-3-3-0 --> 5/0 <-correct
6-2-0-2-8 --> 1/4 wrong - (output should be 2/3 )
5-5-1-7-0 --> 5/0 wrong - (output should be 3/2 )
1-9-1-4-6 --> 2/3 wrong - (output should be 3/2 )
9-3-2-3-0 --> 3/2 <-correct
2-9-5-0-6 --> 2/3 <-correct
3-3-2-8-5 --> 5/0 wrong -(output should be 4/1 )
9-7-8-6-2 --> 2/3 wrong -(output should be 1/4 )
7-1-1-3-3 --> 3/2 wrong -(output should be 4/1 )
1-4-8-2-3 --> 5/0 wrong -(output should be 4/1 )
7-9-4-8-5 --> 2/3 <-correct
On Column K15 (down) I'm using the following formula :
Please can a guru tell me what i'm doing wrong?
Thank you !
Bookmarks