Need help with Excel..
 

Okay, for some reason (I blame WoW) I completely forgotten how to do this.

Cell C8 : AGE

Cell C10 : PRICE

Age 1 = $100
Age 2 = $200
Age 3 = $300
etc etc

The question is,
If I type 1 at Cell C8, how to make Cell C10 to automatically display $100.
If I type 2 at Cell C8, how to make Cell C10 to automatically display $200.
etc etc

Thanks.

Re: Need help with Excel..
 

Put a formula in C10:

=C8*100

Re: Need help with Excel..
 

I used $100, $200, $300 as it's a simple example. :P

What happened if the amount is
Age 1 = $273
Age 2 = $427
Age 3 = $712

Re: Need help with Excel..
 

i believe its IF then formula do a search in excel. I used to do this in VB but that was years ago. its a dust pile in my brain somewhere :(

Re: Need help with Excel..
 

If your list of prices for the various ages is a longer list, i think you might be looking for a Vlookup table? I am not sure on how to do them, but have tried getting an IF formula to work (with only 3 lines of price options) and had trouble.

Good luck!

Re: Need help with Excel..
 

Yes, Vlookup is the ticket here, try:
=VLOOKUP(C8,$C$4:$D$6,2,FALSE)

"=VLOOKUP(" name of function
"C8" cell whose value is being looked up
"$C$4:$D$6" the table of values being consulted
"2" we want the second column
"FALSE" here I want an exact, not an approximate, result
(Dollar signs mean the range stays constant if you fill down the function. Here you won't need them.)

In your example, you would create a 2*3 table of values
1 273
2 427
3 712
say the table is in the range C4 thru D6

Cell C8 : AGE
In this cell you enter 1,2,3 or whatever
Cell C10 : PRICE
Your vlookup formula goes in cell C10

I use Excel spreadsheets all the time in games, creating tables for reference&

Re: Need help with Excel..
 

Vlookup could be the answer... I've done that a number of times.

Help me help you... spell out *exactly* what you're trying to do. I almost wrote more to answer your first question, but didn't want to write a book ;)

Give all the details of what you're trying to accomplish and why.

Re: Need help with Excel..
 

Vlooklup, I can't seem to remember how to do that now. I'll try though, it might jog down the memory.

Thanks :D

Re: Need help with Excel..
 

Take a look here.

Googling for "how to use vlookup in excel"... :D