Try
=IF(B3="","",IF(AND(B3>=0,B3<=49,MOD(B3,1)=0),CHOOSE(MOD(B3,10)+1,"0,10,20,30","1,11,21,31","2,12,22,32","3,13,23,33","4,14,24,34","5,15,25,35","6,16,26,36","7,17,27","8,18,28","9,19,29"),""))
Try
=IF(B3="","",IF(AND(B3>=0,B3<=49,MOD(B3,1)=0),CHOOSE(MOD(B3,10)+1,"0,10,20,30","1,11,21,31","2,12,22,32","3,13,23,33","4,14,24,34","5,15,25,35","6,16,26,36","7,17,27","8,18,28","9,19,29"),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks