Subscribe to How-To Geek

Welcome to the How-To Geek Forums

We encourage you to register on our forums and post any questions you might have. The How-To Geeks monitor this forum and will respond to your question quickly.

How-To Geek Forums » Microsoft Office

Variable cell value based on contents of another cell

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


Appletom
Appletom
Posts: 101

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 months ago #
 
coates719
coates719
Posts: 101

This will do it:

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

Posted 6 months ago #
 
Appletom
Appletom
Posts: 101

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

Posted 6 months ago #
 
coates719
coates719
Posts: 101

Thanks!

Posted 6 months ago #
 

RSS feed for this topic

Reply

You must log in to post.

Sponsored Links
Getting Started
About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe
wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe
Wfica32.exe
Mobsync.exe
Cmd.exe
Dpupdchk.exe Adobe_Updater.exe

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.