Insert inputs into string

[cloobless]

Hi -- I've been trying to do this for the better part of a morning and can't get it quite right.

I'm simply trying to create a string ("output" below) that inserts inputs from various "input" cells. I know this is easy, but I'm not getting it complete.

Any ideas on how to create the cell references? The actual inputs have a variety of characters and numbers.

Thank you for any ideas or suggestions.

[TABLE="class: grid, width: 700, align: left"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]output string:[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]input1[/TD]
[TD]input2[/TD]
[TD]input3[/TD]
[TD][/TD]
[TD][/TD]
[TD]CalcQuota(ABC > input1 +ZYX (/input2), 5000 * input3)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Try

="CalcQuota(ABC > "&A1&" +ZYX (/"&B1&"), 5000 * "&C1&")"

 

[cloobless]

Hi, Jonmo1 -- thank you so much. I hadn't been using quotes around the entire formula, and I also didn't have ampersands in the right place. It probably would have taken me a while to figure this out. Thank you so much for offering your time and help. I truly appreciate it.

 

[Jonmo1]

You're welcome.