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

Solved
1075 1
cancel
Showing results for
Did you mean:
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
18 - Pluto

Remove the quotes around the numbers in your `IF` formula.

6 Replies 6
18 - Pluto

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",
)
``````
18 - Pluto

Welcome to the Airtable community!

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

5 - Automation Enthusiast

Yes:

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

=
#ERROR!

5 - Automation Enthusiast

Sure!

18 - Pluto

Remove the quotes around the numbers in your `IF` formula.

5 - Automation Enthusiast

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