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

1 Answer

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

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers

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

Need more information on what the numbers are to help further

Posted on Nov 07, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

A rectangular computer chip is 7/8 inch long and 5/16 ich wid. An insulating strip must be put around all sides of the chip. hat is the length of the strip using this formula. P=21+2w


One dimension is the length lower case l, the other is the width w. The perimeter for this rectangle is P= 2*l+2*w=2*(l+w)=2*(7/8 +5/16)
=2*(14/16+5/16)= 2*(19/16)=19/8 inches.

Sep 23, 2014 | Computers & Internet

1 Answer

I cashed in $28000.00 from a deposit of $25000.00 after a year how much per cent did i earn . what is the formula


Percent change=100% * (NEW value-OLD value)/(OLD value)
If the change is positive, that is an increase. If negative, that is a decrease.

Sep 18, 2014 | The Learning Company Achieve! Math &...

1 Answer

What is the pyramid total surface formula


Assuming the base of the pyramid is square ... of length B and the distance from the center of the base of the pyramid to the top of the pyramid is H

Surface area is: 2 x H x B
plus B-square (if you include the base of the pyramid)

May 23, 2014 | Encore Math Advantage Algebra II and...

1 Answer

Khan academy


Since you have the coordinates of the three vertices, the most straightforward method is to calculate the length of the sides using the distance formula
d(P_1,P_2)=SQRT((X_1-X_2)^2+(Y_1-Y_2)^2)
where SQRT is the square root function, X_1, Y_1) are the coordinates of point P_1, etc.
With the three lengths available, use Heron's (sometimes called Hero's) to find the area.
Here is Heron's formula.
Let's call the lengths a, b, and c
Let p be the semi-perimeter p= (a+b+c)/2
Then
Area= SQRT [ p(p-a)(p-b)(p-c) ]
Make sure that there is a matching ) parenthesis to the one in the SQRT.

Alternatively,
You can choose the base as the side opposite the vertex (0,0)
Calculate the equation of the line that supports the base.
Calculate the equation of the line issuing from (0,0) and perpendicular t the base.
Calculate the coordinates of the intersection point , call it H, of the base and its perpendicular line (coming from (0,0)).
Calculate the distance OH, that is the height relative to the chosen base.
Use the formula Area= base*height/2

Now it is up to you to choose one of the two methods and calculate the area of that triangle. The second method involves more calculations than the first, and more possibilities of errors. Good Luck

Nov 06, 2013 | Mathsoft Computers & Internet

1 Answer

What is the area of the triangle with vertices (0,0),(-3,5),(2,-7)


Since you have the coordinates of the three vertices, the most straightforward method is to calculate the length of the sides using the distance formula
d(P_1,P_2)=SQRT((X_1-X_2)^2+(Y_1-Y_2)^2)
where SQRT is the square root function, X_1, Y_1) are the coordinates of point P_1, etc.
With the three lengths available, use Heron's (sometimes called Hero's) to find the area.
Here is Heron's formula.
Let's call the lengths a, b, and c

Let p be the semi-perimeter p= (a+b+c)/2
Then
Area= SQRT [ p(p-a)(p-b)(p-c) ]
Make sure that there is a matching ) parenthesis to the one in the SQRT.

Alternatively,
You can choose the base as the side opposite the vertex (0,0)
Calculate the equation of the line that supports the base.
Calculate the equation of the line issuing from (0,0) and perpendicular t the base.
Calculate the coordinates of the intersection point , call it H, of the base and its perpendicular line (coming from (0,0)).
Calculate the distance OH, that is the height relative to the chosen base.
Use the formula Area= base*height/2

Now it is up to you to choose one of the two methods and calculate the area of that triangle. The second method involves more calculations than the first, and more possibilities of errors. Good Luck

Nov 06, 2013 | The Learning Company Achieve! Math &...

1 Answer

What is the effect on the area of a triangle if the base is doubled and the height is cut in half? What happens to the area, if the base is doubled and the height remains the same?


Use the formula for the area of the triangle Area=b*h/2.
If the base becomes b'=2b and h'=h/2, then the area of this new triangle is Area'= (2b)*(h/2)/2.
As you can see the two 2's introduced cancel one another and the area is unchanged. A'=A.

If the base is doubled and the height remains the same, then b''=2b, and h''=h. Substitute in the area formula for a triangle to get
A''=b''*h''/2= (2b)*h/2= 2*(b*h/2)=2A
You see that in this case the area is doubled.

Jan 18, 2012 | Computers & Internet

1 Answer

Wat is special product


Here, We deal with Some Special Products in Polynomials.

Certain products of Polynomials occur more often
in Algebra. They are to be considered specially.

These are to be remembered as Formulas in Algebra.

Remembering these formulas in Algebra is as important
as remembering multiplication tables in Arithmetic.

We give a list of these Formulas and Apply
them to solve a Number of problems.

We give Links to other Formulas in Algebra.

Here is the list of Formulas in
Polynomials which are very useful in Algebra.
Formulas in Polynomials :

Algebra Formula 1 in Polynomials:

Square of Sum of Two Terms:

(a + b)2 = a2 + 2ab + b2
Algebra Formula 2 in Polynomials:

Square of Difference of Two Terms:

(a - b)2 = a2 - 2ab + b2
Algebra Formula 3 in Polynomials:

Product of Sum and Difference of Two Terms:

(a + b)(a - b) = a2 - b2
Algebra Formula 4 in Polynomials:

Product giving Sum of Two Cubes:

(a + b)(a2 - ab + b2) = a3 + b3
Algebra Formula 5 in Polynomials:

Cube of Difference of Two Terms:

(a - b)3 = a3 - 3a2b + 3ab2 - b3 = a3 - 3ab(a - b) - b3
Algebra Formula 8 in Polynomials:


Each of the letters in fact represent a TERM.

e.g. The above Formula 1 can be stated as
(First term + Second term)2
= (First term)2 + 2(First term)(Second term) + (Second term)2

Jul 02, 2011 | Computers & Internet

1 Answer

What does f(x) means?


This is a mathematical notation for a function of a variable x.
Let there be two quantities say the number of hours worked per week (x) and the salary you get paid (y).
The number of hours you work is the independant variable. The salary paid is the dependant variable.
For each amount of hours you work, your boss calculates the salary that is owed you at the end of the week. The method your boss uses to calculate your salaray is the function.
Symbolically, this can be represented as
Salary ($)=f(hours vorked) or
y=f(x)

For example: if the hourly rate is 8$/h and you work 35h then what is owed you is
35h*8$/h=280$
If you work more hours you will get more pay and if less hours, less pay
The rule is y=8*x

Jun 16, 2010 | Vivendi Excel@ Mathematics Study Skills...

1 Answer

The total cost of C of producing n articles per hour in a factory is given by the formula C = a + bn where a and b are constants When 10 articles are produced the total cost is 320 when two are produced...


For this type of problem, a equals the constant cost of operation (monthly rent..etc) and b equals the cost to manufacture the items.

first equation: 320 = a + b(10)
second equation: 520 = a +b(20)

320 = a + 10b
520 = a + 20b subtract equation 2 from equation 1

-
200 = -10b divide by -10

20 = b plug b into one of the equations

320 = a +(20)(10) multiply

320 = a +200 subtract 200

120 = a

Let me know if i need to explain further.

Dec 29, 2009 | Mathsoft StudyWorks! Mathematics Deluxe...

1 Answer

Mathematical Calculation


Following formula we can use.

S=P(1+RT)
WHERE S =INVEST AMOUNT+PROFIT
P=INVEST AMOUNT
R= RATE OF RETURN
T=TIME IN YEARS

EX : (300+x) = x(1+(5.4/100)*1)
(300+x)*100 = 105.4x
x=30000/5.4
x=5555. 4

Jan 05, 2008 | The Learning Company Achieve! Math &...

Not finding what you are looking for?
Microsoft Excel 2000 Step by Step (1572319747) for PC Logo

Related Topics:

134 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...