+ Start a Discussion
Lukasz PiziakLukasz Piziak 

Formula Help Required

Hi All,
I'm wondering if someone can help me with creating formula to convert field input to the 3digit code. In my application user is providing a length in mm. eg value of 1000mm for 1 meter. My code structure is as follow:
 Code   Value
0           0
1           1
2           2
3           3
4           4
5           5
6           6
7            7
8            8
9            9
A         10
B          11
 So for the following length of 11.5MT code should be B50
                                         for 10.85MT code should be A85
I can have two seperate field input, first for meters only and second for cm if that would help with converting to the required code.

Many thanks for any ideas.
Raj VakatiRaj Vakati
You can try with Case function .. that may be the best way to do it