Is ther a way to add two cells with text to equal another cell that contains
text?

basic example:

cell:yellow + cell:green = cell:blue

I have multiple choices for information that I would like to be able to add
together (ex. yellow and green)to equal an already established answer,(ex.
blue). Can I assign numeric values to these text cells so a formula will work?

You could use an IF function. For example if A1:yellow and B1:green, and you
wanted C1 to say blue, then you could try the formula
=IF(A1="yellow",IF(B1="green","Blue",""),""). This formula would return Blue
in whatever cell you placed it in (C1 in this example), and would return
nothing if either A1:B1 was different or blank.
I hope this helps!

"Frank" wrote:

Is ther a way to add two cells with text to equal another cell that contains
text?

basic example:

cell:yellow + cell:green = cell:blue

I have multiple choices for information that I would like to be able to add
together (ex. yellow and green)to equal an already established answer,(ex.
blue). Can I assign numeric values to these text cells so a formula will work?

In place of "Blue" you could just put D5 (withouth the quotation marks). The
formula will now put in C1 whatever you enter in D5 - if yellow is in A1 and
green is in B1. The formula would now look like this:
=IF(A1="yellow",IF(B1="green",D5,""),""). Does this help?

Cam

"Frank" wrote:

Thanks for the input, here is a follow up question

What if Blue is already another cell value (D5) this example. Using your
example could you have the formula return (D5) in cell (C1) if A1=yellow, and
B1=green.

"Cam1234" wrote:

You could use an IF function. For example if A1:yellow and B1:green, and you
wanted C1 to say blue, then you could try the formula
=IF(A1="yellow",IF(B1="green","Blue",""),""). This formula would return Blue
in whatever cell you placed it in (C1 in this example), and would return
nothing if either A1:B1 was different or blank.
I hope this helps!

"Frank" wrote:

Is ther a way to add two cells with text to equal another cell that contains
text?

basic example:

cell:yellow + cell:green = cell:blue

I have multiple choices for information that I would like to be able to add
together (ex. yellow and green)to equal an already established answer,(ex.
blue). Can I assign numeric values to these text cells so a formula will work?

Thanks for the input, here is a follow up question

What if Blue is already another cell value (D5) this example. Using your
example could you have the formula return (D5) in cell (C1) if A1=yellow, and
B1=green.

"Cam1234" wrote:

You could use an IF function. For example if A1:yellow and B1:green, and you
wanted C1 to say blue, then you could try the formula
=IF(A1="yellow",IF(B1="green","Blue",""),""). This formula would return Blue
in whatever cell you placed it in (C1 in this example), and would return
nothing if either A1:B1 was different or blank.
I hope this helps!

"Frank" wrote:

Is ther a way to add two cells with text to equal another cell that contains
text?

basic example:

cell:yellow + cell:green = cell:blue

I have multiple choices for information that I would like to be able to add
together (ex. yellow and green)to equal an already established answer,(ex.
blue). Can I assign numeric values to these text cells so a formula will work?