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()
)
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.
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()
)
)
)
Thanks mate, you’re a beast.