Youredone82
New Member
- Joined
- May 31, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hello,
i have a sheet I use for my recipes, it has the ingredients listed as rows, and in the columns are the amounts of ingredients needed in oz. if I type in an outside designated cell say 4 portions, the end column returns how many oz of each ingredient I need.
i would like to be able to reverse that formula to lets say add in the amount of an ingredient I have on hand, and have the other rows repopulate with the appropriate amount based on that cells input.
is it possoble to have an excel cell both be a output and an input?
Thanks for any answers
i have a sheet I use for my recipes, it has the ingredients listed as rows, and in the columns are the amounts of ingredients needed in oz. if I type in an outside designated cell say 4 portions, the end column returns how many oz of each ingredient I need.
i would like to be able to reverse that formula to lets say add in the amount of an ingredient I have on hand, and have the other rows repopulate with the appropriate amount based on that cells input.
is it possoble to have an excel cell both be a output and an input?
Thanks for any answers