Formula Assistance
 

Question.
How can I use the mathematical value of one cell as a "text value" in
another.
I suppose what I need the cells mathematical value as a "text string"
in another cell.

For example,
I have three Columns-----Column A, Column B, Column C

Column A= "Stations"
Column B= "Sets"
I am solving for Column C= "Average Reps"

Column A Column B Column C
Stations Sets Average Reps
15 45 X
15 45 X
12 36
12 24

Pretty straight forward how to do this.

Column C =3 =sum(b1/a1)

However, what I want to do is create a formula that will allow me to
place text description in the Average Reps cell.


For example, in Average Reps Cell "C" I would like
=sum(b1/a1)& " Reps by"{value of colum A}<---{Right there, I want
whatever the number is in cell under column A}

After the word "by", I want to have the cell contents of column a1 to
show up...

So, using the example above, the cells will look like this

Column A Column B Column C
Stations Sets Average Reps
15 45 3 Reps by 15
15 45 3 Reps by 15
12 36 3 Reps by 12
12 24 2 Reps by 12


I tried the formula

=SUM(b1/a1)&" by" a1

and of course this does not work.

I'm not sure how to properly treat Column A's value as "Text" for
Column C's Text Description.

Formula Assistance
 

Almost there.

Not the SUM is redundant.

=B1/A&" Reps by"&A1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"A_Rookie" wrote in message
...
Question.
How can I use the mathematical value of one cell as a "text value" in
another.
I suppose what I need the cells mathematical value as a "text string"
in another cell.

For example,
I have three Columns-----Column A, Column B, Column C

Column A= "Stations"
Column B= "Sets"
I am solving for Column C= "Average Reps"

Column A Column B Column C
Stations Sets Average Reps
15 45 X
15 45 X
12 36
12 24

Pretty straight forward how to do this.

Column C =3 =sum(b1/a1)

However, what I want to do is create a formula that will allow me to
place text description in the Average Reps cell.


For example, in Average Reps Cell "C" I would like
=sum(b1/a1)& " Reps by"{value of colum A}<---{Right there, I want
whatever the number is in cell under column A}

After the word "by", I want to have the cell contents of column a1 to
show up...

So, using the example above, the cells will look like this

Column A Column B Column C
Stations Sets Average Reps
15 45 3 Reps by 15
15 45 3 Reps by 15
12 36 3 Reps by 12
12 24 2 Reps by 12


I tried the formula

=SUM(b1/a1)&" by" a1

and of course this does not work.

I'm not sure how to properly treat Column A's value as "Text" for
Column C's Text Description.

Formula Assistance
 

Thank you!
I thought I was dancing around it...
"Rookie"


On Jan 4, 11:43 am, "Bob Phillips" wrote:
Almost there.

Not the SUM is redundant.

=B1/A&" Reps by"&A1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"A_Rookie" wrote in message

...

Question.
How can I use the mathematical value of one cell as a "text value" in
another.
I suppose what I need the cells mathematical value as a "text string"
in another cell.

For example,
I have three Columns-----Column A, Column B, Column C

Column A= "Stations"
Column B= "Sets"
I am solving for Column C= "Average Reps"

Column A Column B Column C
Stations Sets Average Reps
15 45 X
15 45 X
12 36
12 24

Pretty straight forward how to do this.

Column C =3 =sum(b1/a1)

However, what I want to do is create a formula that will allow me to
place text description in the Average Reps cell.

For example, in Average Reps Cell "C" I would like
=sum(b1/a1)& " Reps by"{value of colum A}<---{Right there, I want
whatever the number is in cell under column A}

After the word "by", I want to have the cell contents of column a1 to
show up...

So, using the example above, the cells will look like this

Column A Column B Column C
Stations Sets Average Reps
15 45 3 Reps by 15
15 45 3 Reps by 15
12 36 3 Reps by 12
12 24 2 Reps by 12

I tried the formula

=SUM(b1/a1)&" by" a1

and of course this does not work.

I'm not sure how to properly treat Column A's value as "Text" for
Column C's Text Description.