List

[Besh]

If A1 is "=50*2", A2 is "=50*3" and A3 is "=50*5"

What formula would I need to put in a cell to list the answers like this:

100, 150, 250

Thanks, Besh

 

[T. Valko]

If A1 is "=50*2", A2 is "=50*3" and A3 is "=50*5"

What formula would I need to put in a cell to list the answers like this:

100, 150, 250

Thanks, Besh

Like this...

=A1&", "&A2&", "&A3

 

[Besh]

Thanks for your response, when I do that I just get: "TRUE"

 

[T. Valko]

Thanks for your response, when I do that I just get: "TRUE"

Hmmm...

I think it's impossible to get a result of TRUE using the EXACT formula I suggested.

Book1
	A
1	100
2	150
3	250
4	_
5	100, 150, 250
6	=A1&", "&A2&", "&A3
Sheet1

 

[Besh]

Meh, I must have done something wrong I guess. Either way, I looked up another example based on what you told me and I was able to do what I was hoping.

Thanks again, Besh

 

[T. Valko]

Meh, I must have done something wrong I guess. Either way, I looked up another example based on what you told me and I was able to do what I was hoping.

Thanks again, Besh

Good deal. Thanks for the feedback!