I have a number code up to 6 digits long. If there are less than 3 digits(blank,1 or 2) I want to return 9999.
I want to multiply the last digit by 5,the second last digit by 2.5 and third last digit by 1.
I then want to add these 3 together.
I can manage most of this,but anywhere an zero occurs,I want to regard it as ten for computation purposes.
I attach a sheet with the result I require in col c,working on string in col b.
If possible I would like to do all of this with 1 formula(solution in 1 column)