Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-18-2016, 11:31 AM
richardst richardst is offline Recalculating Increments of 1oz, 32nd, 64th, 128th Windows 10 Recalculating Increments of 1oz, 32nd, 64th, 128th Office 2010 64bit
Novice
Recalculating Increments of 1oz, 32nd, 64th, 128th
 
Join Date: Jun 2016
Posts: 3
richardst is on a distinguished road
Default 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!!
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Recalculating Increments of 1oz, 32nd, 64th, 128th Amending dates and recalculating duration seanpears99 Project 1 12-03-2012 07:18 AM
Adding a long column of time increments in seconds klippert Excel 1 09-18-2010 12:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft