03-24-2009, 12:03 AM | #1 |
40th Level Warrior
Join Date: March 24, 2002
Posts: 10,215
|
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. |
03-24-2009, 12:17 AM | #2 |
40th Level Warrior
Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
|
Re: Need help with Excel..
Put a formula in C10:
=C8*100
__________________
*B* Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last. |
03-24-2009, 12:45 AM | #3 |
40th Level Warrior
Join Date: March 24, 2002
Posts: 10,215
|
Re: Need help with Excel..
I used $100, $200, $300 as it's a simple example.
What happened if the amount is Age 1 = $273 Age 2 = $427 Age 3 = $712 |
03-24-2009, 08:15 AM | #4 | |
Jack Burton
Join Date: March 21, 2001
Location: Philippines, but now Harbor City Sydney
Age: 41
Posts: 5,556
|
Re: Need help with Excel..
Quote:
__________________
Catch me if you can.. |
|
03-24-2009, 03:13 PM | #5 |
Elminster
|
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!
__________________
I am the Walrus! |
03-24-2009, 07:55 PM | #6 |
Avatar
Join Date: December 9, 2007
Posts: 594
|
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& |
03-24-2009, 07:56 PM | #7 |
40th Level Warrior
Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
|
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.
__________________
*B* Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last. |
03-25-2009, 11:40 PM | #8 |
40th Level Warrior
Join Date: March 24, 2002
Posts: 10,215
|
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 |
03-26-2009, 08:06 AM | #9 |
40th Level Warrior
Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
|
Re: Need help with Excel..
__________________
*B* Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Help. | Target | General Discussion | 7 | 03-21-2009 03:06 PM |
Excel Help please. | Target | General Discussion | 2 | 09-22-2008 10:55 AM |
Need help with Excel.. | Kakero | General Discussion | 3 | 11-15-2005 06:13 AM |
VBA in Excel | Jorath Calar | General Conversation Archives (11/2000 - 01/2005) | 5 | 02-10-2004 11:18 AM |
Excel...Some Help Needed... | FelixJaeger | General Conversation Archives (11/2000 - 01/2005) | 4 | 04-22-2003 08:58 AM |