Question about Microsoft Excel 2000 Step by Step (1572319747) for PC

# 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.

Posted by on

• Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

What are the "cases"? Your example "more then 8 or less then 9 use 400" implies that there is a decimal part e.g. 8.5 . Is that right?

You dont need to test in both directions
e.g. assuming you name the cell with your number in it "cases"
=if(cases<9,400,if(cases<10,410,if(cases<11,420,430)))

Posted on Nov 07, 2008

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What is the area of a right triangle with a base length of 4 in. and a height of 4 in.?

I will not do your homework for you Hun!! Look up your math notes or look on-line for the formula to use!!!

Happy figuring!!

Apr 01, 2017 | The Computers & Internet

### Math Problem: You have an upstream Picking department that feeds two downstream packing departments: A and B. 75% of your Pick volume goes to department A, which has a packing rate of 150 unites per labor...

Stream
Vol %
Units/Hr
Total Volume
Hrs Reqd
Staff Reqd

Pick
1
100
=(D3*B2)/B3
=D2/C2
=E2/10

Pack A
0.75
150
7500
=D3/C3
=E3/10

Pack B
0.25
25
=D2-D3
=D4/C4
=E4/10

Paste this in an Excel Spread sheet. After pasting it press CTRL+~.

Sep 01, 2010 | Computers & Internet

### I am trying to figure out a payroll formula. I

Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B
8
8
8
2
8
8
0
Total 40 OverTime 2

Formula in this cell where 40 is at:
=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:
=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

### I need help with a change of base formula problem.

It's simple here some logs:

log x base y = log x / log y
log (x*y) = log x + log y
log (x/y) = log x - log y
you just need to know that the default base of log in calculators is 10, so log x mean
log x base 10 = log x / log 10,
so write log x / log y for log x base y example:
log 8 base 2 = log 8 / log 2 that is how you write it on calculator, hope it was helpful

Jul 01, 2009 | Texas Instruments TI-83 Plus Calculator

### Excel formula

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)

Sep 14, 2008 | Computers & Internet

### Creating a formula

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,

Jun 18, 2008 | Computers & Internet

### I have misplaced the directions for the Bissell powersteamer powerbrush. I need the directions for filling the u tank etc.

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
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.

Apr 29, 2008 | Bissell 1699 ProHeat Clear View Upright...

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.

Hope this will FixYa!!!

Mar 03, 2008 | Computers & Internet

#### Related Topics:

139 people viewed this question

Level 3 Expert

Level 3 Expert