Formula issue

Hi,

Can someone please help with a formula issue? Think it is missing ({ or something.

1st formula working:

if(Contains([Bottler Name], "ADMIRAL") AND [RB_CORP_GRP]="ADMIRAL")then [RB_BTTLR_ID] else "x" endif

2nd formula works til black words:

if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK" and Contains ([RB_CORP_GRP],"ROCK"),[RB_BTTLR_ID]), [BP Billing #] endif

Thanks in advance,

Cheryl

Accepted answers

Its tough because we don't know the exact purpose of the formula but this is my best guess:

if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") and Contains ([RB_CORP_GRP],"ROCK") then [RB_BTTLR_ID]) else [BP Billing #] endif

Below highlighted might be the few issue. Where its missing syntax.

if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") and Contains ([RB_CORP_GRP],"ROCK")

then [RB_BTTLR_ID]

else [BP Billing #] endif

Hope this helps 🙂

Try this:

if
([BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") AND Contains ([RB_CORP_GRP],"ROCK"))
THEN [RB_BTTLR_ID])
ELSE
[BP Billing #] ENDIF

Its tough because we don't know the exact purpose of the formula but this is my best guess:

if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") and Contains ([RB_CORP_GRP],"ROCK") then [RB_BTTLR_ID]) else [BP Billing #] endif

Hi @Morgan_Thomas smart use of strike through on bracket ) 🙂 Had never thought of it. Great trick😀

As soon as I type then the balance of formula goes black.

It is all in Vstring and compare numbers to number and then I throw in the X when something does not match

What can I provide you to help explain?

Thanks this did it! appreciate the help, I mean really appreciate.