Visit the Ironworks Gaming Website Email the Webmaster Graphics Library Rules and Regulations Help Support Ironworks Forum with a Donation to Keep us Online - We rely totally on Donations from members Donation goal Meter

Ironworks Gaming Radio

Ironworks Gaming Forum

Go Back   Ironworks Gaming Forum > Ironworks Gaming Forums > General Discussion

Reply
 
Thread Tools Search this Thread
Old 03-24-2009, 12:03 AM   #1
Kakero
40th Level Warrior
 

Join Date: March 24, 2002
Posts: 10,215
Default 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.
Kakero is offline   Reply With Quote
Old 03-24-2009, 12:17 AM   #2
Bungleau
40th Level Warrior
 

Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
Default 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.
Bungleau is offline   Reply With Quote
Old 03-24-2009, 12:45 AM   #3
Kakero
40th Level Warrior
 

Join Date: March 24, 2002
Posts: 10,215
Default 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
Kakero is offline   Reply With Quote
Old 03-24-2009, 08:15 AM   #4
Harkoliar
Jack Burton
 

Join Date: March 21, 2001
Location: Philippines, but now Harbor City Sydney
Age: 40
Posts: 5,556
Default Re: Need help with Excel..

Quote:
Originally Posted by Kakero View Post
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.
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
__________________

Catch me if you can..
Harkoliar is offline   Reply With Quote
Old 03-24-2009, 03:13 PM   #5
Captain Obvious
Elminster
 
Penguin Bashing Champion Simon Champion Snakeman Champion
Join Date: May 21, 2006
Location: New Zealand
Age: 41
Posts: 420
Default 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!
Captain Obvious is offline   Reply With Quote
Old 03-24-2009, 07:55 PM   #6
Shadow Stranger
Avatar
 

Join Date: December 9, 2007
Posts: 594
Default 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&
Shadow Stranger is offline   Reply With Quote
Old 03-24-2009, 07:56 PM   #7
Bungleau
40th Level Warrior
 

Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
Default 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.
Bungleau is offline   Reply With Quote
Old 03-25-2009, 11:40 PM   #8
Kakero
40th Level Warrior
 

Join Date: March 24, 2002
Posts: 10,215
Default 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
Kakero is offline   Reply With Quote
Old 03-26-2009, 08:06 AM   #9
Bungleau
40th Level Warrior
 

Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
Default Re: Need help with Excel..

Take a look here.

Googling for "how to use vlookup in 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.
Bungleau is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

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


All times are GMT -4. The time now is 05:48 AM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2024 Ironworks Gaming & ©2024 The Great Escape Studios TM - All Rights Reserved