Tennisguuy
Well-known Member
- Joined
- Oct 17, 2007
- Messages
- 564
- Office Version
- 2016
- Platform
- Windows
I have the following formula in cell A13 IF(AND(H6>0,J8<-0.02,L6>-0.02),"MANAGEMENT SIGN-OFF IS NEEDED",""). If the value of J8 is -.01 the true statement appears but -.01 is not less than -.02. I know it has to do with comparing double negatives. The problem is sometime the result in J8 could be positive or negative.