formula for money additions & subtractions

M

manickmj

I am trying to get a formula to calculate payroll deduction for cas
register +/-. When an employee is over by $10 or under by $24, th
difference comes out of thier check.

Example: if somone is -25.00 for the month $1.00 would come out of th
check. If someone is +11.00 then $1.00 would come out of the chec
also.

the +/- for the month is in one cell so i would like the formula to b
able to read that cell and figure out if it is too much or little fo
the deduction.

this is the greatest sight that i have ever found and i hope someon
can help me

Thank you,
Mik
 
C

Charlie

Try

=IF(OR(A2<-24,A2>10),1,"")

Assuming A2 contains the over or under amount.

Charlie O'Neill
 
Top