Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
Solved
Jump to Solution
2522 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Christyan_Matos
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

Sure!

image
image
image

Remove the quotes around the numbers in your IF formula.

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