SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Variable cell value based on contents of another cell

(4 posts)
  • Started 6 years ago by Appletom
  • Latest reply from coates719
  • Topic Viewed 5075 times

Appletom
Posts: 133

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.

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.

Posted 6 years ago
Top
 
coates719
Posts: 102

This will do it:

=IF(B6="Office Depot",8,IF(B6="Office Max",9,""))

Posted 6 years ago
Top
 
Appletom
Posts: 133

Ten minutes to an answer that I've been hunting for on my own for at least an hour. Thank you coates719!

Posted 6 years ago
Top
 
coates719
Posts: 102

Thanks!

Posted 6 years ago
Top
 



Topic Closed

This topic has been closed to new replies.