Forum Discussion
help with coding via comparison operators!
Hello, I've got a data set of about 1000 cells that I'm trying to have excel lump into categories. This is my coding sequence: Age 65-74 - 0 75-84 - 1 85-94 - 2 95+ - 3 I'm strug...
Hi Philippe,
1. The IF formula you have tried should be like this.
=IF(AND(H2>64,H2<=74),1,0)
2. I can't get you what you want.
3. Show screet shot of data. And ask clearly what you want. COUNT or anything else.
Sample file or screenshot much better to solve.