Excel formula calculating between #'s

[manickmj]

I am working on a bonus chart and this is what I am trying to do:

If an employee keeps his register balances between -$10.00 thr
+$10.00, they recieve 100 points. If they are out of that range the
get 0 points. I have tried playing with "IF" formulas until I am blu
in the face. Please help

Thanks
Mike Manic

 

[Frank Kabel]

Hi Mike
try something like
=IF(AND(A1>=-10,A1<=10),100,0)

 

[Dana DeLouis]

Other ways:

=IF(ABS(A1)<=10,100,0)

=100*(ABS(A1)<10)