Forum Discussion
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 ...
The logic is not clear, would you like to return Native/Exotic if
- all cells in the range contain value in H55, or;
- any cells, at least one, in the range contain value in H55, or;
- to show the flag against each cell in the range if it is Native/Exotic
Hi SergeiBaklan
I am trying to get "any cells, at least one, in the range contain value in H55", so when I type in a species name if it is listed in the range it is native if it is not in that range it is exotic.