Hi guys, I was wondering what functions would help me make a budget that can be used to create all sorts of hypotheticals involving different variables. That's probably confusing so let me give an example. Say I set up a budget with three variables Items Sold, Price, and Revenue.
All I know how to do now would be to set it up so a single one of those can be calculated if I put in the variables of the other two. So I could calculate the price I would have to sell items at if I had certain revenue goals and a set inventory. What I want to be able to do is have the system be ?fluid so that it can solve for which ever variable is left empty.
Is this possible? Thanks.
Bookmarks