I am building a macro (to run on a CHC) to log serial numbers and operator IDs for later database query at a relatively large foundry.
Our Serial format is nonconsecutive as follows
123A
I am using a line of code to concatenate several (manual) operator entries into a single string where:
#500-#503 are numerical digits
#504 is an alpha character
#805 is the numerical translation of the serial number
#805=[[ROUND[[[[#500-48]*100]+[[#501-48]*10]+[#502-48]+[[#503-64]/100]]*100]]/100]
The trouble that I am having is that the final digit, which should always read in increments of 0.01 is plagued with what appears to be a floating point error. The effort towards placing the numerical value and the alpha value into a single variable is in hopes that the operator can verify the value and reenter as necessary.
This seems to be an extremely simple task, but I've put the above line together numerous ways, always to be plagued with a similar error.
Any suggestions?