Ironworks Gaming Forum - View Single Post

Kakero · 03-24-2009, 12:03 AM

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:03 AM	#1
Kakero 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.