Excel Spreadsheet - plugging in numbers

Question

Hello,

I'm trying to create a spreadsheet where I can plug in numbers. What I mean by this is...

I am trying to figure out a way to work with our numbers to come up with a total income of $50,000 with five different member tiers. I would like to create an excel spreadsheet, where I can enter a number and then from there it uses the number that I enter and then works with my formula. For example:

If my third tier of membership costs $50...

I want it so that if I enter "3" in an empty field, that it automatically will sum to $150.

Is there a way to do this?

Thanks so much!

Answer 1

Could you be more specific, as to get result of 150, we have to just multiply the membership cost ($50) to the number entered by you which is 3.

So may be you can set up a table, where column 1 have the membership fee and column B will contain number of members and in column C just multiply like A2*B2,  then you can do the sum of column C.

For getting the result of 50000, you may use 'goal seek'.