I want to do this: status is B7 and B7 equals RED so it give

Feb 27th, 2002, 11:33 AM

So let's say that in B7 there is the word RED. I would like to do have in another cell something like (Status is B7). So in fact excel will show: Status is RED.

How can I do that?

Thanks in advance!

gplhl · Feb 27th, 2002, 11:39 AM

Quote:

On 2002-02-27 10:33, Anonymous wrote:
So let's say that in B7 there is the word RED. I would like to do have in another cell something like (Status is B7). So in fact excel will show: Status is RED.

How can I do that?

Thanks in advance!

="Status is "&B7

Feb 27th, 2002, 01:45 PM

It works!

Thanks a lot!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 11:33 AM	#1
Guest Posts: n/a	So let's say that in B7 there is the word RED. I would like to do have in another cell something like (Status is B7). So in fact excel will show: Status is RED. How can I do that? Thanks in advance!

Feb 27th, 2002, 01:45 PM	#3
Guest Posts: n/a	It works! Thanks a lot!