Hello
here is my formula
=IF(ISERROR(IF(OR(D10-C10<>1,C10="12+"),1,0)),1,IF(OR(D10-C10<>1,C10="12+"),1,0))
C10 = 1
D10 = 2
E10 = 3
.....N10 = 12
i have numbers list from 1-12
basically, if the number sequence is out of order, i want in C9:N9 to show 1 through this formula
however, C10:N10 = 12+ .....then i want that to show 1 as well
my formula for some reason doesnt seem to work when i make C10:N10 = 12+
pls help!
Bookmarks