Forum Discussion

Copper Contributor

Nov 29, 2019

how to join two IF statement together and flag out the False?

please see the file ..i typed my question in the file. I really need to work this. My question is IF B2 = Dist Owned, C2 = Blank, This is True, Or B2= Company owned, C2= Yes, this is also True. How...

Gabriel.xlsx19 KB

excel

SergeiBaklan

Diamond Contributor

Nov 29, 2019

Popo49008

As variant

=( (I2="X")*(G2="KC owned") + (I2="")*(G2="Dist owned") )<>0

Gabriel.xlsx20 KB

Popo49008
Copper Contributor
Nov 29, 2019
Sergei, thanks for the quick reply. I tried your formula in the Excel file. It didn't work...can you please attached in excel file? The excel prompt 'problem with formula...
- SergeiBaklan
  Diamond Contributor
  Nov 29, 2019
  Popo49008
  
  File is attached to my previous post, please check