Switch Formula Not Returning a Number - HELP

Objective: I want to return a number if a cell has a certain text in it and then multiply that number by another number to return a total value

For example: If Content Type Column says TikTok then return number 30.

However when I use the Switch function like this:

“UGC - TikTok”, “30”,
“UGC - Review”, “25”,
“UGC - How To”, “20”

It shows a number but isn’t recognised as a number, therefore I am unable to multiply it against another column/variable to measure total cost.

E.g. 30 * 5 (no of videos) = $150

[Content type cost] * [No of videos] = #ERROR!

How to solve?

Welcome to the community, @Ryan_Thorpe!

You’ll need to remove the quotation marks from your numbers.


Oh my, I just remembered VALUE() exists. And this might actually be a use case for it (assuming the quotes and the numbers are coming from the same field, it would be more convenient to drag them through VALUE than fiddle with index numbers or regex.

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