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

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
easycapitalAsked:
Who is Participating?
 
nutschCommented:
try

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

Thomas
0
 
easycapitalAuthor Commented:
Works. I was missing the "&".
Thanks,
JP
0
 
nutschCommented:
Glad to help.

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.