Have the following array formula: =IF(L34=HOLEC,10,IF(L34=HOLEC-1,5,IF(L34=HOLEC+1,5,IF(L34=HOLEC-2,2,IF(L34=HOLEC+2,2,IF(L34=HOLEC-3,2,IF(L34=HOLEC+3,2,0)))))))
The values in L34 and in both cells of HOLEC are simple numerical values between 1 and 16.
HOLEC represents two adjacent cells. This formula works correctly but only for the values in the first cell of HOLEC not the second.
Can someone suggest what my problem may be or a work around?
Thanks, Michael
Bookmarks