How to multiply comma separated value


Is it possible in airtable?

This is possible, but only if you know for a fact that you will only have two values in each set.

Try this:

VALUE(LEFT({Field 1}, FIND(",", {Field 1}) - 1)) * VALUE(LEFT({Field 2}, FIND(",", {Field 2}) - 1)) & "," & VALUE(RIGHT({Field 1}, FIND(",", {Field 1}) + 1)) * VALUE(RIGHT({Field 2}, FIND(",", {Field 2}) + 1))
1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.