Forum Discussion
table set up for mail merge
Re challenge #1:
The =IF(H2<1,"Priority",IF(H2=1.1>=2.9,"CatchUp",IF(H2>3,"Refresher"))) will indeed never come to the "Refresher" stage as the second test H2=1.1>=2.9 will always evaluate as TRUE and thus return "CatchUp". Obviously your intention is to test if the value is between 1.1 and 2.9, but that's not the way to achieve it. You could use IF(AND(H2>=1.1,H2<=2.9),...... but that's unnecessary.
Change the order of the logical_tests in stead.
=IF(H2>=3,"Refresher",IF(H2>=1.1,"CatchUp","Priority"))
Re challenge #1:
The =IF(H2<1,"Priority",IF(H2=1.1>=2.9,"CatchUp",IF(H2>3,"Refresher"))) will indeed never come to the "Refresher" stage as the second test H2=1.1>=2.9 will always evaluate as TRUE and thus return "CatchUp". Obviously your intention is to test if the value is between 1.1 and 2.9, but that's not the way to achieve it. You could use IF(AND(H2>=1.1,H2<=2.9),...... but that's unnecessary.
Change the order of the logical_tests in stead.
=IF(H2>=3,"Refresher",IF(H2>=1.1,"CatchUp","Priority"))
Oh i see now Riny - THANK YOU ! Riny_van_Eekelen