Best answer

"Invalid Syntax: Only numeric values are allowed" when using an IF function

  • 23 April 2024
  • 1 reply
  • 22 views

I’m using an IF formula to return value A (“Internal”) or value B (“Public”) depending on what a cell looks like in my Google Sheet.

The error I get is “Invalid Syntax: Only numeric values are allowed”. 

I saw a similar post about using JavaScript code, but I’m not sure if this is the correct solution for me let alone how to implement.

 

icon

Best answer by Troy Tessalone 23 April 2024, 00:53

View original

1 reply

Userlevel 7
Badge +14

Hi @Lauryn 

Try putting double quotes around the mapped variable.

Reply