Trying to assign ABC priority based on size of discrepancy

[billfinn]

I'm tracking down some discrepancies and am attempting to prioritize them as ABC or D. I thought this would be simple but...
My criteria is that if a cell value is more than 1000 or less than -1000 it would be classified as an A priority
If >500 and < 1000 or <-500 and >-1000 is a B
If >100 and < 500 or <-100 and >-500 is a C
<100 is a D
I've been scratching my head as to what is causing my issue, but essentially it doesn't assign priority as I expected. the A,B and C priorities assign as expected but D doesn't seem to make it into the decision
Any thoughts or input would be very much appreciated
Thanks,Bill

=IF(M2>OR1000<(-1000),"A",IF(M2>AND500<1000,"B",IF(M2<and(-500)>(-1000),"B",IF(M2<and500>100,"C",IF(M2>AND(-500)<(-100),"C",IF(M2<and100>0,"D",IF(M2>AND(-100)<0,"D"))))))))

</and100></and500></and(-500)>

 

[Fluff]

How about
=IF(ABS(M2)>1000,"A",IF(ABS(M2)>500,"B",IF(ABS(M2)>100,"C","D")))

 

[Fluff]

Alternatively, as I've just learnt
=VLOOKUP(ABS(M2),{0,"D";101,"C";501,"B";1001,"A"},2,1)

 

[billfinn]

Thanks much Fluff! I changed the 0 to a 1 and added 0,"" so blank lines wouldn't zero out but this is just what I needed.
Thanks for your help!
Bill

 

[Fluff]

Glad to help & thanks for the feedback