Posted by v9p 4 years ago In:

,

v9p
v9p Asked:

I created a list and can't figure out how to make a certain value in another cell when a certain text is choosen, any advice would help

Liked this question? Tell your friends about it

2 Answers

Order by
Oldest to Newest
Newest to Oldest
Votes
markpx
markpx Answered:

use the IF function

IF(value in list column="specific text",if true expression,if false expression)

to fully answer this question may require more details

Regards

Add a comment Report
justanotherusername
justanotherusername Answered:

markpx hit the nail on the head.  Excel's 'IF' function is extremely useful.  Here's a page with more details on the syntax:

http://www.techonthenet.com/excel/formulas/if.php 

Add a comment Report

Related Questions

Other people asked questions on similar topics, check out the answers they received:

FC

Asked: Excel, Formulas

Hi all, I'm hoping for some help asap on an Excel formula I am working on. In column A I have reference nos for issues brought to my attention. In column B I have the year the issue was 'opened ...
  • Posted by FC 2 years ago
LOU

Asked: How do i get column a to the left side in excel ...

How do i get column a to the left side in excel 2003
  • Posted by LOU 4 months ago
FC

Asked: Excel forumla, IF and SUM

I have two columns of data that I am recording in an annual budget. The first column (Column D) is the amount spent. The second column (column E) indicates which GB country this relates to (ie, E ...
  • Posted by FC 3 years ago