Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 82
Default Adding one to two figures with moving decimals

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding one to two figures with moving decimals Loadmaster Excel Worksheet Functions 0 November 25th 09 11:19 PM
Adding one to two figures with moving decimals Loadmaster Excel Worksheet Functions 1 November 25th 09 03:55 PM
Adding one to two figures with moving decimals Loadmaster Excel Worksheet Functions 0 November 25th 09 06:57 AM
adding moving decimals in more than one cell Loadmaster Excel Worksheet Functions 0 November 25th 09 03:53 AM
Can surplus decimals be omitted when adding derived figures? DBB9 Excel Worksheet Functions 2 December 29th 07 12:53 AM


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"