Dual If Statements

[Anonymous]

Hello,

I am new to the coding and working on an If statement that has an additional condition in the False position that is meant to narrow the selections for Brooder down to 17.

Here is what I have and the opposite of CONVENTIONAL is OFFSITE if this matters. My expression is marked as ok, but it only returns a -1 for the result instead of the names that are listed.

IF(Housing = 'CONVENTIONAL',Grower_Name,
       Brooder = 'BURNEY BROODER'
OR  Brooder = 'CC ROAD FARM'
OR  Brooder = 'C&C QUICK TURN'
OR  Brooder = 'C&D BROODER'
OR  Brooder = 'DKC BROODER'
OR  Brooder = 'HONEYCUTT FAMILY BROODER HUB'
OR  Brooder = 'HUDSON BROODER'
OR  Brooder = 'J & K BLACKMON BROODER'
OR  Brooder = 'KIMS BROODER HUB'
OR  Brooder = 'L&C BROODER'
OR  Brooder = 'MAGUIRES BROODER FARM'
OR  Brooder = 'R&S BROODER'
OR  Brooder = 'RANDY SMITH BROODER HUB'
OR  Brooder = 'S & A TANNER BROODERS'
OR  Brooder = 'WAYNE SMITH'
OR  Brooder = 'WILSON FAMILY BROODER HUB'
OR  Brooder = 'WINDY CREEK BROODER FARM')

Any help you can offer will be greatly appreciated.

Thanks,

Bradley Faircloth

[MK_QSL]

What you want to achieve?

[CELAMBARASAN · Accepted solution]

May be something like this

IF(Housing = 'CONVENTIONAL',Grower_Name,
      IF(Brooder = 'BURNEY BROODER'
OR  Brooder = 'CC ROAD FARM'
OR  Brooder = 'C&C QUICK TURN'
OR  Brooder = 'C&D BROODER'
OR  Brooder = 'DKC BROODER'
OR  Brooder = 'HONEYCUTT FAMILY BROODER HUB'
OR  Brooder = 'HUDSON BROODER'
OR  Brooder = 'J & K BLACKMON BROODER'
OR  Brooder = 'KIMS BROODER HUB'
OR  Brooder = 'L&C BROODER'
OR  Brooder = 'MAGUIRES BROODER FARM'
OR  Brooder = 'R&S BROODER'
OR  Brooder = 'RANDY SMITH BROODER HUB'
OR  Brooder = 'S & A TANNER BROODERS'
OR  Brooder = 'WAYNE SMITH'
OR  Brooder = 'WILSON FAMILY BROODER HUB'
OR  Brooder = 'WINDY CREEK BROODER FARM', Brooder ))

[Anonymous]

That's it, I wasn't putting the extra Brooder at the end of the coding.

Thanks for your help.

[jerem1234]

Just as an addition, you might be able to reduce your code a bit with the match function (so you don't need the extra OR's and 'Brooder ='s, like:

IF(Housing = 'CONVENTIONAL',Grower_Name,
      IF(Match(Brooder, 'BURNEY BROODER', 'CC ROAD FARM', 'C&C QUICK TURN',

          'C&D BROODER', 'DKC BROODER', 'HONEYCUTT FAMILY BROODER HUB',

          'HUDSON BROODER', 'J & K BLACKMON BROODER', 'KIMS BROODER HUB',

          'L&C BROODER', 'MAGUIRES BROODER FARM', 'R&S BROODER', 'RANDY SMITH BROODER HUB',

          'S & A TANNER BROODERS', 'WAYNE SMITH', 'WILSON FAMILY BROODER HUB',

          'WINDY CREEK BROODER FARM'), Brooder))

Hope this helps!

[Anonymous]

Thanks, I will keep that in mind.