-----Original Message-----
Answers below:
1. Every sheet I moved that contained a formula that
refered to another sheet in the book is now refering to
its original book.
I.E. New book 1, sheet 1, cell A1 = [old book 1] sheet
2, cell A1.
Is there an easy way to remove tat referance to the old
book or will I have to retype each formula. I did
copy "sheet 2" to the new book as well and the sheet
names have not changed.
You should be able to go to Edit . . .Links. Choose the
name of the old workbook, click Change Source, and find
the location of the new workbook.
2. One of the sheets is a payroll calculator. I have 2
saleried employee's that need to be added to the daily
total. What formula can I use to add there salery only if
hours are added for them.
I.E.
A1=Name, A2=salery,A3=Hours,A4=Cost
What I would like to do is have A4=A2 if A3 has any
number greater then zero. I know from the help section it
is possible but I'm having no luck getting it to work.
Try =if(a3>0,a2,0)
Finally. I designed a weekly schedule writer that
calculates the hours worked each day in tenths of an hour
and subracts .5 for a lunch from all non-salery
employee's. I did not write the formula myself, and I
have found a problem with it. I would like to have it
deduct .5 only if the scheduled hours exceed 6.
I.E.
A1=8:00 AM, A2=5:00 PM, A3=8.5
A3 Fx is =IF((OR(A2="",A1="")),0,IF((A2<A1),((A2-A1)*24)
+24,(A2-A1)*24)-.5)
Change to :
=IF((OR(A2="",A1="")),0,IF(IF((A2<A1),((A2-A1)*24)+24, (A2-
A1)*24)>6,IF((A2<A1),((A2-A1)*24)+24,(A2-A1)*24)-0.5,IF
((A2<A1),((A2-A1)*24)+24,(A2-A1)*24)))
Jane
.
