Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #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!!
  #2  
Old 06-21-2016, 06:06 PM
macropod's Avatar
macropod macropod is offline Recalculating Increments of 1oz, 32nd, 64th, 128th Windows 7 64bit Recalculating Increments of 1oz, 32nd, 64th, 128th Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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

Thread Tools
Display Modes


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 01:04 AM.


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