AND(B2>1,B2<-1) always return FALSE
i think it should be:
=IF(AND(B2>-1,B2<1)"WRITE OFF","")
Or
=IF(ABS(B2)<1,"WRITE OFF","")
AND(B2>1,B2<-1) always return FALSE
i think it should be:
=IF(AND(B2>-1,B2<1)"WRITE OFF","")
Or
=IF(ABS(B2)<1,"WRITE OFF","")
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks