Question Locked

Excel Formula Query

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hello everyone, this is my first post, so I hope you can help me. I am trying to create an excel inventory spreadsheet which logs the sales of products and then automatically updates the ingredient inventory list that made up that product. For example if I sold 1 ham sandwich which used 2 slices of bread, 2 slices of ham, 10grams of butter, 1 plastic container and 1 label - then by entering "1" into the "ham sandwiches sold" column, would some how link to and update the ingredients sheet behind it. This would mean ingredients stock levels would be managed by the products sold column, rather than manually updating each ingredient/component column. Any ideas?

5 replies

by naresh.p1007

You are thinking very logical and programmatic.

But Yes, You can achieve this with common excel formulas.

Not quite sure, I feel the Nested IF statements can be a help for you.

Just check if this works fine?

by cgsstwy

Thank you so much for replying, really appreciate it. I have not used the nested IF statements, as I am a basic user, but I will google them and see if I can make sense of them. If anyone has helpful tips on how to apply them to my problem, i'd welcome your input. :-)

by gkarvindr

put a formula that points to the cell in the sheet..

e.g. ='Sheet1'!A1 in each other sheet will copy what is in cell A1 of Sheet1 in each of those cells...

instead of ='Sheet1'!A1 , substitute your formula, put the sheets name in single quote
for more details write to gkarvind@it-infratech.in or visit http://it-infratech.in

This discussion is closed to new replies.