Solved

Display text depending of the values on different columns (excel 2003)

Posted on 2011-03-08
3
278 Views
Last Modified: 2012-05-11
If content in B1 = 1, then display "Project"
If content in C1 = 1, then display "Good"
If content in D1 = 1, then display "South"

So if the values on B1, C1, D1 are 1, 0, 1 respectively, then the it should display where ever we place the formula: "Project Good"

Thanks,
JP
0
Comment
Question by:easycapital
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 35074999
try

=TRIM(IF(B1=1,"Project ","")&IF(C1=1,"Good ","")&IF(D1=1,"South",""))

Thomas
0
 

Author Closing Comment

by:easycapital
ID: 35075115
Works. I was missing the "&".
Thanks,
JP
0
 
LVL 39

Expert Comment

by:nutsch
ID: 35075127
Glad to help.

Thomas
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question