Forum Discussion
Solved
Greetings, I hope you are well. I just need some formula help.
I have several cells in a row that have Y or N in them, I want to enter a formula in a column for when one of those cells in a row is "Y" to return a "Y" value. Also I have in those cells returnin...
UKBlueSteel ,,,
- For Row has Y & N:
=IF(COUNTIF($A$2:$E$2,"Y")>0,"Y","N") Or to make the formula dyanamic,, you can use this even: =IF(COUNTIF($A$2:$E$2,A1)>0,"Y","N") Where A1 has Y, or you may put other alphaet to test.- To check the products:
=IF(OR(A1={"Steel","Cooper","Nickel"}),"Y","N") For Ni and others: =IF(OR(A1={"St","Co","Ni"}),"Y","N")
UKBlueSteel ,,,
- For Row has Y & N:
=IF(COUNTIF($A$2:$E$2,"Y")>0,"Y","N")
Or to make the formula dyanamic,, you can use this even:
=IF(COUNTIF($A$2:$E$2,A1)>0,"Y","N")
Where A1 has Y, or you may put other alphaet to test.- To check the products:
=IF(OR(A1={"Steel","Cooper","Nickel"}),"Y","N")
For Ni and others:
=IF(OR(A1={"St","Co","Ni"}),"Y","N")