Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
267 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.