Add constant to each item in list

Is it possible to add a constant to each item in a List such that:

List(1, 4, 8) + 6 becomes

List(7, 10, 14)

Thank you.

No. If the 1, 4 & 8 are in a table then Iā€™d suggest adding the 6 there and then pulling in that new figure as a list.

The only way I can think of how to do it as you describe would be to pull out each item, add 6, then merge to make a new list:

LIST(
	INDEX(List(1, 4, 8),1)+6
	,
	INDEX(List(1, 4, 8),2)+6
	,
	INDEX(List(1, 4, 8),3)+6
)

Simon@1minManager.com

1 Like

Thanks Simon