Table "What If" Set Up If I Change One Or Two Variables

[John Johnston]

I saw someone do this a couple of weeks ago, so maybe
someone can tell me how it's done.
I have the following information:
cars trucks vans average %
4 3 3
4% 3% 3% 3.333%

I want to have Excel create a table that will allow me to
change the number of cars ordered and generate the
adjusted average:
cars average %
4 3.333%
5 3.6666%
6 4%
7 4.333%

Also, what do I do to change two variables. Like this:
cars
3 4 5
vans 2 2.667% 3% 3.333%
3 3% 3.333% 3.667%
4 3.333% 3.667% 4%

 

[k.courtney.hoffman]

Does anyone know how to do this in Excel 2010?

 

[Spencer101]

Does anyone know how to do this in Excel 2010?

Your post doesn't make it clear what you're actually tying to achieve
Perhaps you could provide some more information....