Solved

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

Posted on 2011-03-08
3
272 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
  • 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now