IF(Find) formula

Hi,
I am having trouble with my IF(Find) formula. It is working for the first half of the formula but not catching the other "IF(Find). Here is what I have so far:

IF(FIND(‘TR’,{Name}),‘Trade’,IF(FIND(‘PR’,{Name}),‘Private’))

It is making them all “Trade” and not picking up on the “Private”. Screenshot below for reference

Hi @Aly_Fossett ,

In your screenshot, it looks to me like every entry DOES have an instance of ‘TR’ in the name that precedes any instances of ‘PR’.

Try specifying the demarcations you used in the name along with the letters to give you a more accurate target to FIND():

IF( FIND( '- TR -', {Name}), 'Trade', … etc
1 Like

Duh - I totally looked over that. You are correct- thanks!

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.