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!!
|