Question about Microsoft Office Professional 2007 Full Version for PC

Trying to find a formula that finds the triple root (not sure of name) of a number. Similar to square root of a number. Using excel 2003. Thanks

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

What follows is true for CONVEX polygons.

Let**n **be the number of sides of a convex polygon, and let** n** **be greater than or equal to 4**, then

The number of diagonals is given by**n*(n-3)/2**

Using this rule, write**n*(n-3)/2**=20. Clear the fraction, open brackets. You end up with **n^2-3n-40=0**.

Factor the polynomial or use the formulas for the quadratic equation to find the roots as** n=-5 or n=8**. Discard the negative root because n must be positive.

Let

The number of diagonals is given by

Using this rule, write

Factor the polynomial or use the formulas for the quadratic equation to find the roots as

Oct 05, 2013 | Computers & Internet

Correct a #N/A error
Show All
Hide All
This error occurs when a value is not available to a function or formula.

- Optionally, click the cell that displays the error, click the button that appears , and then click
**Show Calculation Steps**if it appears. - Review the following possible causes and solutions.
Missing data, and #N/A or NA() has been entered in its place

Replace #N/A with new data.

**Note**You can enter**#N/A**in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.

Giving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function

Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. Using the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table

By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.

Using an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula

If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).

Omitting one or more required arguments from a built-in or custom worksheet function

Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.

Using a custom worksheet function that is not available

Make sure that the workbook that contains the worksheet function is open and the function is working properly.

Running a macro that enters a function that returns #N/A

Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

If you imported all your sim contacts &google contacts the phone might now hav some numbers duplicated or even tripled and then does not know which name to display when you receive a call from a number listed on multiple accounts. Go to your contacts & check all the boxes to display all possible contacts you hav- sim, google, phone, sd card, etc. Go through the list &try to take out all the numbers listed under more than one contact name! Even if it is the same name! It takes some time to sort out if you hav a lot of contacts, but that fixed my problem! Good luck!

Jun 18, 2013 | Samsung Galaxy Pocket

Most calculators (except perhaps the TI89) can't do this sort of simplification, so you will need to factorise the number yourself to get sqr(200) = sqr(2*100) = sqr(2) * sqr(100) = sqr(2) * 10.

May 29, 2012 | Casio FX-7400G Plus Calculator

Hi,

If you are unable to locate your serial number for the game you have a couple of options. The are outlined below. I wrote a tech article which goes over these options in some more detail. Click the link below to read my tech article.

How to obtain serial key

Outline

-Contact Sims tech support and see if they can provide a new one. Click here for the support page.

-Purchase a new copy of the game thus getting a new serial number.

-Bypass the game activation using a crack program or files.

Let me know if you have any questions.

Regards,

G33k

If you are unable to locate your serial number for the game you have a couple of options. The are outlined below. I wrote a tech article which goes over these options in some more detail. Click the link below to read my tech article.

How to obtain serial key

Outline

-Contact Sims tech support and see if they can provide a new one. Click here for the support page.

-Purchase a new copy of the game thus getting a new serial number.

-Bypass the game activation using a crack program or files.

Let me know if you have any questions.

Regards,

G33k

Aug 05, 2011 | EA - Electronic Arts The Sims Triple...

Solve the formula e^(rt) = 3 , where r=0.06 per time period

(see http://en.wikipedia.org/wiki/Compound_interest#Continuous_compounding for details)

Taking the logarithm of both sides and rearranging gives: t = ln(3)/0.06 = 18.31 time periods. The logarithm function is a shifted function on the 2 button on the 10bii calculator.

(see http://en.wikipedia.org/wiki/Compound_interest#Continuous_compounding for details)

Taking the logarithm of both sides and rearranging gives: t = ln(3)/0.06 = 18.31 time periods. The logarithm function is a shifted function on the 2 button on the 10bii calculator.

May 09, 2011 | HP 10bII Calculator

Hey!

I'm not sure what do you mean by "underroot", but if it's the square root that you need, the formula is as follows:

=SQRT(A1)

and also:

=A1^(1/2) - the square root

=A1^(1/3) - the cube root

etc...

For more info, look here...

Regards,

Pelu.

I'm not sure what do you mean by "underroot", but if it's the square root that you need, the formula is as follows:

=SQRT(A1)

and also:

=A1^(1/2) - the square root

=A1^(1/3) - the cube root

etc...

For more info, look here...

Regards,

Pelu.

Feb 09, 2011 | Business Industrial Network Free MS Excel...

#include<stdio.h>

#include<conio.h>

#include<math.h>

void main()

{

int a;

printf("enter no");

scanf("%d",&n);

printf("sqr(n.0.5)");

}

#include<conio.h>

#include<math.h>

void main()

{

int a;

printf("enter no");

scanf("%d",&n);

printf("sqr(n.0.5)");

}

Jan 11, 2009 | ArcMedia JavaScript Source Code 3000 Pro...

assuming the question is what is the circle equation?

and if (-2,2) is the center of the circle

the equation should look like this: (x+2)^2+(Y-2)^2=R^2

And now only R is needed.

given 2x-5y+4=0 equation of line perpendicular

we can rearange the equation to be y=(2x+4)/5

from that we can see that the slope of the line is 2/5

And from the fact of perpendicular line we can say that the slope

of the radius line is -2/5.

The motivation now is to calculate the distance between the center of the circle to the cross point of the radius with the line perpendicular

For that we would calculate the radius line equation and compare it to the equation of line perpendicular

As mentioned earlier the slope of the radious line is -2/5.

So the equation is y=-2/5x+b and b can be calculated by using the center of the circle coordinates

2= - (2/5)*(-2)+b ------> b=2-4/5=1.2

radius equation is y=-(2/5)x+1.2

Now the cross point is calculated by comparing the equations:

-(2/5)x+1.2=(2x+4)/5 --> -2x+6=2x+4 --> 4x=2 --> x=1/2 --> y=1

So the cross point is (1/2,1).

The distance between the points is calculated by the following

Formula:

R=SQR(((1/2)-(-2))^2+(2-1)^2)=SQR(2.5^2+1^2)=SQR(6.25+1)=

SQR(7.25)

Therefore the circle eq is (x+2)^2+(Y-2)^2=7.25

and if (-2,2) is the center of the circle

the equation should look like this: (x+2)^2+(Y-2)^2=R^2

And now only R is needed.

given 2x-5y+4=0 equation of line perpendicular

we can rearange the equation to be y=(2x+4)/5

from that we can see that the slope of the line is 2/5

And from the fact of perpendicular line we can say that the slope

of the radius line is -2/5.

The motivation now is to calculate the distance between the center of the circle to the cross point of the radius with the line perpendicular

For that we would calculate the radius line equation and compare it to the equation of line perpendicular

As mentioned earlier the slope of the radious line is -2/5.

So the equation is y=-2/5x+b and b can be calculated by using the center of the circle coordinates

2= - (2/5)*(-2)+b ------> b=2-4/5=1.2

radius equation is y=-(2/5)x+1.2

Now the cross point is calculated by comparing the equations:

-(2/5)x+1.2=(2x+4)/5 --> -2x+6=2x+4 --> 4x=2 --> x=1/2 --> y=1

So the cross point is (1/2,1).

The distance between the points is calculated by the following

Formula:

R=SQR(((1/2)-(-2))^2+(2-1)^2)=SQR(2.5^2+1^2)=SQR(6.25+1)=

SQR(7.25)

Therefore the circle eq is (x+2)^2+(Y-2)^2=7.25

Oct 26, 2008 | Casio FX-115ES Scientific Calculator

try using the formula "sumif". It allows you to sum by category/name.
Good luck!
D.

Sep 12, 2007 | Microsoft Office Standard for PC

734 people viewed this question

Usually answered in minutes!

Thanks, I was loking all over excel help for this.

×