Forum Discussion
what if Analysis
That's a question that could have many answers. At the very simplest level, you want to use a field off by itself to enter that variable percentage. I've attached a simple example. Please come back if I've missed your actual need.
Thank you for taking the time too reply this might be give you a better indicator of what im trying to do,I want too populate the yellow column with the unit price value increased by f12,the box with the 22% in it
So this looks like a homework assignment of some kind. Right?
In any event, I think the sample spreadsheet I provided above should give you the answer in terms of how to approach it. You'd have to adapt the formula to your specific sheet. (FWIW, an image is not all that helpful in requesting help on these pages; we almost always prefer a sample of the actual sheet.)
mathetes no no no,it was an exam we did on tuesday and im now going over the parts I did not get and trying too figure out how to do them,but I just I fundamentally do not understand how to do this with what if analysis and
I understand that this something best figured out on my own,but does the scenario manager suffice for this? or am I supposed too be using goal seek or data table? or even if their any resoruces youd be able too point too because even after reading on the microsoft office page for what if-analysis im still not fully sure what to do