Microsoft Office Forums Recalculating Increments of 1oz, 32nd, 64th, 128th
 User Name Remember Me? Password
 Register FAQ Search Today's Posts Mark Forums Read

 Thread Tools Display Modes
#1
06-18-2016, 11:31 AM
 richardst Windows 10 Office 2010 64bit Novice Join Date: Jun 2016 Posts: 3
Recalculating Increments of 1oz, 32nd, 64th, 128th

If I have in cells:
A1(ounces)B1(32nd)C1(64th)D1(128th)
Then I need to add additional amounts in cells:E1(ounces)F1(32nd)G1(64th)H1(128th)
I'm trying to figure out how to ADD cells (E1 thur H1) to cells( A1 thru D1) INTO cells I1(ounces)J1(32nd)K1(64th)L1(128th)
I don't know how to create a formula that would take into account if one cell was over their amount then added to the next cell up.
Example: Lets assume A1(ounces) is 1, B1(32nds) is 31 and F1(32nds) is 1, Then I1(ounces) would be 2.
Each cell would change determined by amount in each cell.
Thanks so much in advance!!
#2
06-21-2016, 06:06 PM
 macropod Windows 7 64bit Office 2010 32bit Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 19,533

Thread closed. See discussion in: https://www.msofficeforums.com/excel...-end-time.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post seanpears99 Project 1 12-03-2012 07:18 AM klippert Excel 1 09-18-2010 12:26 AM

All times are GMT -7. The time now is 04:18 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top