Thread: IF formula

Hi all, I am trying to return a comment with below logic..if Cell A2 is equal 0 and cell B2 is less than 5000 or more than -5000 then comment = "OK"..

I think i am just missing few pieces..any help would be greatly appreciated

=IF(A2 = 0 AND (B2 < 5000 OR >-5000) "OK"

Thanks so much

Hi

=IF(AND(A2=0,ABS(B2)<5000),"OK","")

Regards