formula for money additions & subtractions

  • Thread starter Thread starter manickmj
  • Start date Start date
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
 
Try

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

Assuming A2 contains the over or under amount.

Charlie O'Neill
 
Mike, if the +/- is in A2, then =IF(A2>10,A2-10,IF(A2<-24,ABS(A2)-24,0)).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subject: Formula for two (or more) "If's" 2
Formula for two "If's" 2
Need help with formula 10
Desperately need help with a formula 2
Subtracting and multiplying tax numbers witht he IF function 2
If Tuesday subtract 4 (Formulas) 3
FORMULA NEEDED FOR MONTHS 1
Please help with subtraction formula 7

Back
Top