fredtriest
New Member
- Joined
- Nov 2, 2016
- Messages
- 14
I was hoping to get assistance with a formula that will look at a numeric value in one cell, and then apply a formula that will take that number and apply itself to another cell with custom text and make increments of +1 on an entirely different number (starting at 1).
For example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]5
[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$5 can buy 1 widget to take home [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$5 can buy 1 widget to take home [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$5 can buy 1 widget to take home [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$10 can buy 2 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$10 can buy 2 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$15 can buy 3 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$15 can buy 3 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$15 can buy 3 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated!
For example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]5
[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$5 can buy 1 widget to take home [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$5 can buy 1 widget to take home [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$5 can buy 1 widget to take home [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$10 can buy 2 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$10 can buy 2 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$15 can buy 3 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$15 can buy 3 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl65, width: 238"]$15 can buy 3 widgets to take home[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated!