Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Switch Formula Not Returning a Number - HELP

Topic Labels: Formulas
Solved
Jump to Solution
335 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

SWITCH(({Select}),
“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?

1 Solution

Accepted Solutions

Welcome to the community, @Ryan_Thorpe!

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

See Solution in Thread

2 Replies 2

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.