Forum Discussion
AND function
I have this issue when i use the AND function it gets all false values when i put this and of course i have values in between =AND(K6>=70157,K6<70176) This was just my first try on this funct...
Most probably your Trim # column is formatted as text or you have text values in proper formatted column. Try =ISTEXT(K6) in any empty cell.