IF and ANDfunction
Trying to setup divisions for 3 sets of handicaps using ‘=IF(C2<=12,$G$2,IF(C2>=13<20,$G$3,IF(C2>20,$G$4)))’ but only getting 1st and last formula to calculate and getting a ‘false’ message for the middle formula-how do I set up this function within the calculation?
Trying to setup divisions for 3 sets of handicaps using ‘=IF(C2<=12,$G$2,IF(C2>=13<20,$G$3,IF(C2>20,$G$4)))’ but only getting 1st and last formula to calculate and getting a ‘false’ message for the middle formula-how do I set up this function within the calculation? Read More