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.
suchetalahiri , wouldn't the result always be TRUE? Maybe I'm missing something. Do you have sample data (without any confidential info) to illustrate?
TheAntonyHi Anthony, I cant share the data as I am doing a research project on it. I don't want true or false, I want it 0 or 1 as the data is to be used for further analysis. Guess even if we can do true or false, we can turn it into 0 or 1 with the further formula, no?