Forum Discussion
Solved
Help me with if then function!
hello members, I will be really grateful if you could help me with this question: I have seven columns that are either filled or not filled. I need a function to fulfil the following conditi...
suchetalahiri , ok, I think I got it. If there are more than 1 values in the categories, then result should be 0. No value or 1 value results in 1. See attached.
TheAntonyHi George, I have uploaded a sample file just to explain the background, please let me know if you can crack it. Thank you, kindly.
suchetalahiri , ok, I think I got it. If there are more than 1 values in the categories, then result should be 0. No value or 1 value results in 1. See attached.
TheAntonyYou're a genius! yes, it did! My next question is what if we have following condition:
We should get 1 if the count is at least two categories or more?
suchetalahiri , you got it. 🙂