If formula Cases 10000, cases per line 8 I am trying to find the hours need to pick the 10000 cases base on how many cases per line. This is how I am trying to write the formula: if the cases per line are more then 8 or less then 9 use 400 cases per hour if the cases per line are more then 9 ore less then 10 use 410 cases per hour etc.

1 Suggested Answer

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).click here to download the app (for users in the US for now) and get all the help you need. Good luck!

Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.

Hello,
The formula should go like this:
=IF(C11>40,(C11-40)*D11,0)
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:
=IF(C11>40,(C11-40)*D11*1.5,0)

go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Release the handle and lay the machine handle
back to access the Tank.
2. Remove the Tank from the base of the machine by
lifting the Tank carry Handle.
3. Carry like a bucket to the sink. Rotate the Handle
forward to unlatch the lid. Lift off and set the lid aside.
4. Fill up the Bladder with clean hot tap water.
*Do not boil or microwave water as it can
destroy the Bladder.
5. Replace the top of the Tank by matching the lid
and tank edges. Handle must be in the forward
position in order to replace lid. Rotate the handle
to the carrying position to latch the lid.
Note: Remember to secure the lid and test to
make sure it is secure before picking up the Tank.
6. Place tank into machine base, seating firmly in place.
Rotate tank handle back into latched position. Bring
machine handle back into upright position.

1. Lift the formula Tank up and out of the machine base.
2. To fill the Formula Tank, first unscrew the Cap
and Insert. Always use genuine BISSELL formulas
to maximize cleaning and for the safety of your
machine. Fill formula up to the line and replace the
Cap and Insert. Place Formula Tank back into the
base of machine, making sure it is seated securely.
Note: If bottle leaks, check for proper positioning
of red gromment and straw.

You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.