http://www.howtogeek.com/forum/ How-To Geek Forums Topic: Variable cell value based on contents of another cell en Fri, 09 Jan 2009 08:45:12 +0000 http://www.howtogeek.com/forum/topic/variable-cell-value-based-on-contents-of-another-cell#post-26041 Sun, 25 May 2008 13:12:36 +0000 coates719 26041@http://www.howtogeek.com/forum/ <p>Thanks! </p> http://www.howtogeek.com/forum/topic/variable-cell-value-based-on-contents-of-another-cell#post-26040 Sun, 25 May 2008 12:54:36 +0000 Appletom 26040@http://www.howtogeek.com/forum/ <p>Ten minutes to an answer that I've been hunting for on my own for at least an hour. Thank you coates719! </p> http://www.howtogeek.com/forum/topic/variable-cell-value-based-on-contents-of-another-cell#post-26038 Sun, 25 May 2008 12:38:01 +0000 coates719 26038@http://www.howtogeek.com/forum/ <p>This will do it:</p> <p>=IF(B6="Office Depot",8,IF(B6="Office Max",9,"")) </p> http://www.howtogeek.com/forum/topic/variable-cell-value-based-on-contents-of-another-cell#post-26037 Sun, 25 May 2008 12:28:13 +0000 Appletom 26037@http://www.howtogeek.com/forum/ <p>I'm doing a mileage spreadsheet for my 2008 taxes and I want the numerical value in column C to be determined based on the text in Column B. </p> <p>So if cell B6 was "Office Depot", I want cell C6 to be "8". If cell B6 is "Office Max", I want cell C6 to be "9". I know I've done this before, but for the life of me I can't remember how and I would be extremely grateful if someone could point me in the right direction. </p>