Skip to main content
Solved

Need help with an IF statement

  • October 25, 2020
  • 4 replies
  • 39 views
M

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.

Any advises?
Thanks.

Best answer by Kamille_Parks11

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

Kamille_Parks11
Forum|alt.badge.img+27

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()
)
M
  • Marcos_Sacrista
  • Author
  • New Participant
  • October 25, 2020

Thanks a lot for your fast reply, It worked.
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.

Kamille_Parks11
Forum|alt.badge.img+27

Thanks a lot for your fast reply, It worked.
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.


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()
      )
   )
)
M
  • Marcos_Sacrista
  • Author
  • New Participant
  • October 25, 2020

Thanks mate, you’re a beast.

Kamille_Parks11
Terms & ConditionsAccessibility statement