# Need help with an IF statement

Topic Labels: Formulas
Solved
1390 4
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hello,

I’m new writting formulas, I’ve read all the guides on airtable’s website and other posts in the forum.
However I can’t get my formula to work. I only need that when the value of a cell is equal to a number a specific name appears.

This is what I’ve wrote; IF (Total = “6.99”, Hernia discal, BLANK())
But airtable won’t let me keep the formula because it’s misspelled.

Thanks.

1 Solution

Accepted Solutions
16 - Uranus

Anything that isn’t a function or the name of a field needs to be in either straight apostrophes or quotation marks. If a field name contains a space it must be surrounded by curly braces.

So your formula should likely be either:

``````IF(
Total = "6.99",
"Hernia discal",
BLANK()
)
``````

or

``````IF(
Total = "6.99",
{Hernia discal},
BLANK()
)
``````
4 Replies 4
16 - Uranus

Anything that isn’t a function or the name of a field needs to be in either straight apostrophes or quotation marks. If a field name contains a space it must be surrounded by curly braces.

So your formula should likely be either:

``````IF(
Total = "6.99",
"Hernia discal",
BLANK()
)
``````

or

``````IF(
Total = "6.99",
{Hernia discal},
BLANK()
)
``````
5 - Automation Enthusiast

What if I want to add different values for total? I’ve tried to duplicate the formula with different values but it doesn’t work,

Something like this:
Total = “6.99”,
“Hernia discal”,
BLANK()
Total = “10.99”,
“Hernia discal lumbar”,
BLANK()
Total = “15.99”,
“Hernia discal cervical”,
BLANK()

Thanks a lot for your help.

16 - Uranus

If you’re comparing the value of one thing multiple times you could use a SWITCH statement.

``````SWITCH(
Total,
"6.99",
"Hernia discal",
"10.99",
"Hernia discal lumbar",
"15.99",
"Hernia discal cervical",
BLANK()
)
``````

For your reference, if you wanted to nest an IF() statement it would look like this:

``````IF(
Total = "6.99",
"Hernia discal",
IF(
Total = "10.99",
"Hernia discal lumbar",
IF(
Total = "15.99",
"Hernia discal cervical",
BLANK()
)
)
)
``````
5 - Automation Enthusiast

Thanks mate, you’re a beast.