if formulas

M

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 thru
+$10.00, they recieve 100 points. If they keep it between +$10.00 thru
-$24.00 they get 50 points. If they are out are out of those at ranges
they get 0 points. I have tried playing with "IF" formulas until I am
blue in the face. Please help


Thank you

Mike Manick
 
C

Charlie

Hi,

Try =IF(AND(A1<=10,A1>=-10),10,IF(AND(A1>10,A1<=24),5,0))
assumning 'A1' is where the balance is kept.

Charlie O'Neill
 
K

kkknie

Just nest a couple of Ifs like so:

=IF((A1<=10)*(A1>=-10)=1,100,IF(((A1<=24)*(A1>=-10))=1,50,0))
 
Top