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 8 years ago by Appletom
  • Latest reply from coates719
  • Topic Viewed 5075 times

PARTNER SPOTLIGHT

Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
Top
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 8 years ago
Top
 
coates719
Posts: 102

This will do it:

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

Posted 8 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 8 years ago
Top
 
coates719
Posts: 102

Thanks!

Posted 8 years ago
Top
 



Topic Closed

This topic has been closed to new replies.