PAYROLL ISSUES

  • Thread starter Thread starter JOHN
  • Start date Start date
J

JOHN

Hello, I posted this this morning and got an answer but
I'm new to excel and I think the person who replied may
have taken for granted my actuall knowlage of what I was
doing. I can minipulate basic formulas but as the
complexity grows my skills shrink... :)


Hi, working on my own employee payroll sheet and I have 4
questions:

1. I have an employee who wants thier direct deposit
split by way of only $75.00 into one account and the
remainder balance into the 2nd account.
So: what I have now is this d16 is the final net
income cell for employee-x, d17 is the cell I'd like to
place the balance(-75.00) and d18 is the cell I'd like to
place the 75.00

2. How do I do an accumulative total on cells or columes,
not auto, but manual so that when I choose too I can
update the running total of somthing like year to date?

3. How do I clear the whole workbook, save it with a date
(week ending xx/xx/xx)and possibly tie that action with
saving the accumulative totals with out eraseing all the
formulas?

4. I need to ad something to this formula that will make
return the #0 if their is no count...

=IF(COUNT(C_TIME,T_TIME)=0,"",IF(COUNT(C_TIME,T_TIME)
<7,COUNT(C_TIME,T_TIME),7))


Thanx for any help at all
JOHN
 
Back
Top