Forum Discussion
AngoDono
Oct 19, 2020Copper Contributor
Logic Test With Text
I am trying create a formula which will produce a "true" or "false" or in my case "native" or "exotic" plant species, the problem is that excel will not recognise my text at the source when I select ...
NikolinoDE
Oct 19, 2020Platinum Contributor
Here is a formula, as far as I could understand the translation.
=IF(OR(EXACT(H55,AA3:AA260)),"Native","Exotic")
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)