Data Input/Output Question

**michael.cholko** · 02-22-2011, 03:31 AM

Now before I get started, I'll state that I'm not sure if I'm even in the correct section for this and my terminology may be off. I apologize for this in advance, but I do think I am in the correct section at the least.

As for my question:

I am using Excel 2010. Essentially, I want users to be able to put in two inputs: level and experience in cells I5 and I6, respectively. Then, I want cells I9 and I10 to output current total experience and experience remaining (values), respectively.

In column B I have all the levels 1 through 5, beginning in B4 ending in B53. Then in column C I have the experience acquired which correlates to the level (level 1 has 0 exp, etc). Then in column D I have the experience remaining until you reach the final level 50.

How would I make it so that when the user inputs their level and current experience for that level it outputs their total experience and experience remaining? AKA, what formulas would I use here?

Thank you.

**Simon Lloyd** · 02-22-2011, 04:21 AM

I don't know your structure or how your data is laid out but you can use a worksheet function without those lists like this:
=CHOOSE(A2,10,20,30,45,50,1)
if the above was in A1 and in A2 i entered 2 the value in A1 would show up as 20, if i enter 4 the value would be 45, if i enter 6 the value would be 1......get the idea?

Without seeing your workbook this is the best suggestion i can give but worksheet functions are always the best option if you can use them.

Data Input/Output Question

LinkBack

Thread Tools

Rate This Thread

Display

Data Input/Output Question

Re: Data Input/Output Question

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions