Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

How to multiply the value returned by the IF Statement without showing an error

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

I’m using IF Statement with return numbers for two conditions: If it’s a car, one value, if it’s a motorcycle, another value.

Everything is ok about that, however, when trying to multiply the presented result, it shows #ERROR!, how to solve it?

1 Solution

Accepted Solutions

Remove the quotes around the numbers in your IF formula.

See Solution in Thread

6 Replies 6

Hm, sounds like the value you’re trying to multiply is a string. Could you paste your formula here so that I can try to provide a suggestion?


A quick thing to check would be whether you’re wrapping the numbers in quotes.

The following would return a value you could multiply by:

IF(
  {Field} = "Car",
  1,
  2,
)

And this would not:

IF(
  {Field} = "Car",
  "1",
  "2",
)

Welcome to the Airtable community!

Can you share a screen capture that shows the column headings and some sample data?

Yes:

IF(
  {Veículo} = "Carro", 
    "1.18",
    IF({Veículo} = "Moto", 
      "0.35"
    )
)

=
#ERROR!

Remove the quotes around the numbers in your IF formula.

That’s right, it worked. Thank you very much.