adding digits 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]

Hmmm,

This must be the eighth time you've posted this and on every occasion you
have failed to respond to requests for additional information or explained
why the answer given doesn't work for you.

Mike

 

[Bernard Liengme]

I got lost!
I have made the table in U2:AC4; in cell R3 I entered 15000
I can see 7.3 under the 1000 so far so good
Why 3.6 under from under 5000 - how do I jump to 5000?

OH! we had 1500 in R3, less 1000 from the second row leaving 500, so we take
1/10 of what is under 5000 -- yes?
The 3.6 vs 3.7 is accomplished with ROUND(Y3/10,1)

To work out the rest, we would need to have some rules and the range of all
possible values that can go in the R cell

Can't be of any help tomorrow but will try later. Email me privately if you
wish - get my addy form my website
best wishes

 

[Rob van Gelder]

I took the time to read this, even though the layout was shocking. Use the enter key please.

You didn't ask a question. What do you want to do?

Cheers,
Rob