- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 06:40 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:35 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:11 AM
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",
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:18 AM
Welcome to the Airtable community!
Can you share a screen capture that shows the column headings and some sample data?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:32 AM
Yes:
IF(
{Veículo} = "Carro",
"1.18",
IF({Veículo} = "Moto",
"0.35"
)
)
=
#ERROR!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:34 AM
Sure!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:35 AM
Remove the quotes around the numbers in your IF
formula.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 25, 2022 07:36 AM
That’s right, it worked. Thank you very much.
