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

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

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

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.

=2*(14/16+5/16)= 2*(19/16)=19/8 inches.

Sep 23, 2014 | Computers & Internet

Percent change=100% * (NEW value-OLD value)/(OLD value)

If the change is positive, that is an increase. If negative, that is a decrease.

If the change is positive, that is an increase. If negative, that is a decrease.

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

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)

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

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

**
**

d(P_1,P_2)=SQRT(

where SQRT is the

With the three lengths available, use Heron's (sometimes called Hero's) to find the area.

Let's call the lengths

Let p be the semi-perimeter p= (a+b+c)/2

Then

Area= SQRT [

Alternatively,

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

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

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

d(P_1,P_2)=SQRT(

where SQRT is the

With the three lengths available, use Heron's (sometimes called Hero's) to find the area.

Let's call the lengths

Let p be the semi-perimeter p= (a+b+c)/2

Then

Area= SQRT [

Make sure that there is a matching ) parenthesis to the one in the SQRT.

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

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

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.

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

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

** (a - b)2 = a2 - 2ab + b2 **

** (a + b)(a - b) = a2 - b2 **

** (a + b)(a2 - ab + b2) = a3 + b3 **

** (a - b)3 = a3 - 3a2b + 3ab2 - b3 = a3 - 3ab(a - b) - b3 **

(First term + Second term)2

= (First term)2 + 2(First term)(Second term) + (Second term)2

Jul 02, 2011 | Computers & Internet

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

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

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.

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

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

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

Apr 07, 2010 | Microsoft Excel 2000 Step by Step...

134 people viewed this question

Usually answered in minutes!

×