Help

Switch Formula Not Returning a Number - HELP

Topic Labels: Formulas
Solved
Jump to Solution
925 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryan_Thorpe
4 - Data Explorer
4 - Data Explorer

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
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Ryan_Thorpe!

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

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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.