Gohar hussain
New Member
- Joined
- May 9, 2021
- Messages
- 1
- Office Version
- 2011
- Platform
- Windows
Hi
I have to create a sheet in excel to calculate total egg production..
Here i have three different units.
Bundles=12 trays
Trays=30 eggs
And eggs
I need a formula which can sum the the production plus old stock in current stock
While maintaining the bundles and trays .
Like if eggs become 30 it should go to trays as 1 ,and if trays become 12 thay should go to bundle as 1.
Thanks
I have to create a sheet in excel to calculate total egg production..
Here i have three different units.
Bundles=12 trays
Trays=30 eggs
And eggs
I need a formula which can sum the the production plus old stock in current stock
While maintaining the bundles and trays .
Like if eggs become 30 it should go to trays as 1 ,and if trays become 12 thay should go to bundle as 1.
Thanks