-
The code above uses the original key which is shown below:
Original key table:
VLx--> +1
Lx --> +2
LMx --> +3.5
Mx --> +5
MHx --> +7
Hx --> +8
VHx --> +9
xA --> x
(x) number
The above key is used to calculate the numbers in sheet 1, which are multiple of 10s.
The new key table:
VLx --> + 0.1
Lx --> +0.2
LMx --> + 0.35
Mx --> +0.5
MHx --> +0.7
Hx --> +0.8
VHx --> +0.9
The new key above is used to calculate numbers in sheet 1, which are NOT multiple of 10s (m56s).
I hope this clarifies the problem.
I have attached the same file with a clearer representation of the output on sheet 1 and the code is behind sheet1.
Price test.xlsm
Thank you for your help and time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules