Try this..
=IF(A1<10,"",IF(OR(AND(MOD(INT(A1/10),2)=0,MOD(A1,2)<>0),AND(MOD(INT(A1/10),2)<>0,MOD(A1,2)=0)),A1,""))
Try this..
=IF(A1<10,"",IF(OR(AND(MOD(INT(A1/10),2)=0,MOD(A1,2)<>0),AND(MOD(INT(A1/10),2)<>0,MOD(A1,2)=0)),A1,""))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks