Ask Your Question
1

use a variable within text

asked 2018-03-09 04:02:13 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi, In my calc sheet I have the name 'wage' for a cell and put my wage value in there so I can use it other places. I would like to use that variable within the text of another cell but can't so far.

eg: "Current houly charge is =(wage) per hour"

I would think this is possible but I'm not seeing this explained in any posts so far. Thanks

edit retag flag offensive close merge delete

Comments

2

Please do not post as Wiki. It helps no one.

Ratslinger gravatar imageRatslinger ( 2018-03-09 04:06:11 +0100 )edit

2 Answers

Sort by » oldest newest most voted
2

answered 2018-03-09 04:14:19 +0100

Ratslinger gravatar image

updated 2018-03-09 04:38:59 +0100

Hello @how0909,

Try =("Current hourly charge is " & (wage) & " per hour")

and =("Current hourly charge is " & wage & " per hour") also works.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more

Comments

The parentheses are not necessary.

erAck gravatar imageerAck ( 2018-03-09 17:32:49 +0100 )edit
0

answered 2018-03-09 04:27:49 +0100

how0909 gravatar image

updated 2018-03-09 04:28:59 +0100

Yes, that does work, great thanks! I had also found concatenate

=CONCATENATE("Current hourly charge is $", wage, " per hour")

but yours is shorter, just need to remember the '&'s. Thanks again!

edit flag offensive delete link more

Comments

2

You welcome.

In future, please use comment to respond. Answers should be used to respond to original question.

Ratslinger gravatar imageRatslinger ( 2018-03-09 04:36:31 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-09 04:02:13 +0100

Seen: 124 times

Last updated: Mar 09 '18