Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 14th 19, 07:55 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2019
Posts: 2
Default Iterative Calculation

Hello,

I have a Situation in sheets wherein I need to find if a particular stock has been fully used up
Eg:
Stock A -- Code1 -- 250units---0(balance)<----[250-100-100-50]

Stock used --- 100 units---Stock A(code 1)
Stock used --- 100 units---Stock A(code 1)

Stock A -- Code 2 -- 300 units---60(balance)<----[300-30(prev.balance)-80-150-60]

Stock used --- 80 units---Stock A(code 1)
Stock used --- 150 units---Stock A(code 1+code 2)
Stock used --- 60 units---Stock A(code 2)

Any help would be much appreciated

thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterative Equation Chris Excel Discussion (Misc queries) 5 March 9th 10 01:32 AM
an iterative calculation -- sort of ali Excel Worksheet Functions 4 July 30th 09 07:57 PM
Iterative solving using VBA ... M100C Excel Programming 3 January 2nd 06 11:47 AM
Iterative process, bioyyy Excel Discussion (Misc queries) 5 December 1st 05 02:07 AM
Iterative Macro Stuart Steven Excel Programming 7 July 14th 04 02:49 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017