Adding numerals with moving decimals

[Loadmaster]

Cells U2:AC2 have 1000-9000 lbs. Cells S3:S14 have Compartments B thru M
Cells U3:AC3 have the following figures corresponding the weights above.
7.3 for 1000 lb in compartment B. 14.6 for 2000 in compartment B. Here are
the rest of the figures for Compartment B; 21.9, 29.2, 36.4, 43.7, 51.0, 58.3
and 65.6. The next row of numbers for Compartment C in row 4 are as follows;
5.4, 10.8, 16.2, 21.6, 27.0, 32.5, 37.9, 43.3 and 48.7. Upon entering a
figure of 1500 in compartment R3, cell AF3 should add to read 7.3 from the
1000 column plus 3.6 from the 5000 column moving the decimal one place over
to the left. Had column Y3 have read 36.5 vice 36.4 you would have added 3.7
vice 3.6 to round it up. If I had put 15000 vice 1500 in cell R3, cell AF3
would read 73.0 plus 36.4 for a total of 109.4 If I had 50 lb in R4 it would
be rounded up to 100 lbs AF4 would read 0.5 from the 5.4 from the 1000 lbs
in compartment C. 3900 in cell R4 would read 16.2 plus 4.9 which is the 48.7
rounded up for the 900 lbs left for a total of 21.1 in cell AF4.

 

[Mike H]

You've posted this question half a dozen times and had offers of help and
requests for additional information and have responded to none of them.

People here are more than willing to help but for your part if you ask a
question then it's a good idea (and good manners) to respond to those offers
of help or you will quickly find people won't bother.

Mike

 

[Michael Arch]

all you need in Cell AF3 is: =ROUNDUP(R3/1000*U3,0)
--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.