Ad

Here is an example:-

We have to calculate result on the basis of marks.

1. Select answer range and click in formula bar

2. Type following formula

=if(d5:D9>=40,"Passed","Failed")

3. Now Press CTRL+SHIFT+Enter key

4. Observe the result in answer range and formula in formula bar, notice { } braces come automatically when we press CTRL+SHIFT+Enter key for an array.

For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

Posted on Sep 16, 2017

Ad

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

Ad

The HP test centers have run a whole host of crazy conditions. One was a test to see if their disk array could with stand the test of fire and decreased oxygen in the room the array is in. They found that even with reduced oxygen and the increased pressure from the pressure fire extinguishers the array was still able to function properly without problems. You can be sure with an HP that it will last almost anything you can throw at it. Although its recommended not to throw things at it.

Oct 17, 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

In the cell that you
want the result to appear in, enter the appropriate formula from the following
examples.

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

A disk array has cache memory and advanced functionality

Jan 23, 2013 | Computers & Internet

samples of arrays in vb.net

1)

dim array(3) as integer

array(0)=1

array(1)=2

array(2)=3

array(3)=4

2) dim array() as integer

array=new integer(){1,2,3,4}

3) for two dimensional arrays add comma separation to the size

1)

dim array(3) as integer

array(0)=1

array(1)=2

array(2)=3

array(3)=4

2) dim array() as integer

array=new integer(){1,2,3,4}

3) for two dimensional arrays add comma separation to the size

May 28, 2010 | Microsoft Visual Basic Enterprise Edition...

The crude solution is:

=IF(Sheet3!I2="WA",IF(Sheet3!H2="Vancouver","X",IF(Sheet3!H2="Camas","X",IF(Sheet3!H2="Ridgefield","X",IF(Sheet3!H2="Washougal","X",IF(Sheet3!H2="Stevenson","X",IF(Sheet3!H2="Hockinson","X",**"?City?"**)))))),**"?State?"**)

Where**?City?** appears when the city referenced in H2 is not part of the lookup

and**?State?** appears when something other than *WA* appears in I2.

But there is probably a better way to do this using an array of valid values like the one below:

AL NY TX WA Birmingham Albany Abilene Camas Huntsville Buffalo Galvaston Hockinson Russell New York Houston Ridgefield Stevenson Vancouver Washougal

In the scenario you could stuff the array in another worksheet and use the HLookup function to find the "Sheet3!I2" value in the first row of this array to determine which column to look in, then VLookup "Sheet3!H2" in the column of that array to see if the city referenced exists. Of course this is a much more complex formula, but it would be easily extendible without changing the formula every time.

For mor info, see "Lookup and Reference Functions" in the Excel Help.

=IF(Sheet3!I2="WA",IF(Sheet3!H2="Vancouver","X",IF(Sheet3!H2="Camas","X",IF(Sheet3!H2="Ridgefield","X",IF(Sheet3!H2="Washougal","X",IF(Sheet3!H2="Stevenson","X",IF(Sheet3!H2="Hockinson","X",

Where

and

But there is probably a better way to do this using an array of valid values like the one below:

AL NY TX WA Birmingham Albany Abilene Camas Huntsville Buffalo Galvaston Hockinson Russell New York Houston Ridgefield Stevenson Vancouver Washougal

In the scenario you could stuff the array in another worksheet and use the HLookup function to find the "Sheet3!I2" value in the first row of this array to determine which column to look in, then VLookup "Sheet3!H2" in the column of that array to see if the city referenced exists. Of course this is a much more complex formula, but it would be easily extendible without changing the formula every time.

For mor info, see "Lookup and Reference Functions" in the Excel Help.

Jun 11, 2009 | Microsoft Excel for PC

the best thing to do here is to separate the steps for calculating the variance into different functions. To compute the variance the first thing to do is to compute the mean or the average of the numbers in the array. so your first function will loop through each of the numbers and divide it by the length of your array. the output is the returned. The next thing to do is create another function for the variance. loop through each of the numbers again and subtract to each number the mean. square the value then add to the previous. so that means you have another variable that starts from zero and just adds the answer. after that divide it by the length of the array again and what you are going to get is the value for the variance.

May 13, 2009 | Computers & Internet

To start points and lines are not shapes, and a triangle is not representable with a single function, therefore you need a function to draw shapes , given a number of points as parameters, and one to draw math functions (lines etc.).

Here is an example:*Draw* Line, Ellipse, Polygon **...**

From website above, here is script in JS:

"<script type="text/javascript">

<!--

function myDrawFunction()

{

jg_doc.setColor("#00ff00");*// green*

jg_doc.fillEllipse(100, 200, 100, 180);*// co-ordinates related to the document*

jg_doc.setColor("maroon");

jg_doc.drawPolyline(new Array(50, 10, 120), new Array(10, 50, 70));

jg_doc.paint();*// draws, in this case, directly into the document*

jg.setColor("#ff0000");*// red*

jg.drawLine(10, 113, 220, 55);*// co-ordinates related to "myCanvas"*

jg.setColor("#0000ff");*// blue*

jg.fillRect(110, 120, 30, 60);

jg.paint();

jg2.setColor("#0000ff");*// blue*

jg2.drawEllipse(10, 50, 30, 100);

jg2.drawRect(400, 10, 100, 50);

jg2.paint();

}

var jg_doc = new jsGraphics();*// draw directly into document*

var jg = new jsGraphics("myCanvas");

var jg2 = new jsGraphics("anotherCanvas");

myDrawFunction();

//-->

</script>"

Here is an example:

From website above, here is script in JS:

"<script type="text/javascript">

<!--

function myDrawFunction()

{

jg_doc.setColor("#00ff00");

jg_doc.fillEllipse(100, 200, 100, 180);

jg_doc.setColor("maroon");

jg_doc.drawPolyline(new Array(50, 10, 120), new Array(10, 50, 70));

jg_doc.paint();

jg.setColor("#ff0000");

jg.drawLine(10, 113, 220, 55);

jg.setColor("#0000ff");

jg.fillRect(110, 120, 30, 60);

jg.paint();

jg2.setColor("#0000ff");

jg2.drawEllipse(10, 50, 30, 100);

jg2.drawRect(400, 10, 100, 50);

jg2.paint();

}

var jg_doc = new jsGraphics();

var jg = new jsGraphics("myCanvas");

var jg2 = new jsGraphics("anotherCanvas");

myDrawFunction();

//-->

</script>"

Oct 25, 2008 | Computers & Internet

An array is a series of elements of the same type placed in contiguous memory locations that can be individually referenced by adding an index to a unique identifier

Initializing arrays. When declaring a regular array of local scope (within a function, for example), if we do not specify otherwise, its elements will not be initialized to any value by default, so their content will be undetermined until we store some value in them. The elements of global and static arrays, on the other hand, are automatically initialized with their default values, which for all fundamental types this means they are filled with zeros

include <iostream>

using namespace std;

int billy [] = {16, 2, 77, 40, 12071};

int n, result=0;

int main ()

{

for ( n=0 ; n<5 ; n++ )

{

result += billy[n];

}

cout << result;

return 0;

}

multidimensional array pseudo-multidimensional array #define WIDTH 5 #define HEIGHT 3 int jimmy [HEIGHT][WIDTH]; int n,m; int main () { for (n=0;n<HEIGHT;n++) for (m=0;m<WIDTH;m++) { jimmy[n][m]=(n+1)*(m+1); } return 0; } #define WIDTH 5 #define HEIGHT 3 int jimmy [HEIGHT * WIDTH]; int n,m; int main () { for (n=0;n<HEIGHT;n++) for (m=0;m<WIDTH;m++) { jimmy[n*WIDTH+m]=(n+1)*(m+1); } return 0; }

and now for trignometry

#include<iostream>

#include<cmath>

using namespace std;

int main()

{

int factorial(int);

int n = 3, i = 1;

double x, x2, b, PI, r;

char choice;

//r = x * (PI / 180)

cout<<"Please enter an angle value => ";

cin>>x;

cout<<"Is the angle value in Degree or Radian?"<<endl;

cout<<"Type D if its in degree "<<endl;

cout<<"Type R if its in radian "<<endl;

cin>>choice;

if((choice = 'R')||(choice = 'r'))

do{

i++; n = 3; x2 = 0; b = x2;

{

if(i == 1)

x2 = x - (pow(x,n) /factorial(n));

n = n + 2;

};

else

{

x2 = (x2 + ((pow(x,n)) /(factorial(n))) - (pow(x,n+2)) / (factorial(n+2)));

n = n + 4;

}

}while(abs(b - x2) > 0.000001);

else

//convert it to r

r = x * PI /180;

//cout<<"error occured/n";

cout<<"sin(x) = "<<x2<<endl;

return 0;

}

Initializing arrays. When declaring a regular array of local scope (within a function, for example), if we do not specify otherwise, its elements will not be initialized to any value by default, so their content will be undetermined until we store some value in them. The elements of global and static arrays, on the other hand, are automatically initialized with their default values, which for all fundamental types this means they are filled with zeros

include <iostream>

using namespace std;

int billy [] = {16, 2, 77, 40, 12071};

int n, result=0;

int main ()

{

for ( n=0 ; n<5 ; n++ )

{

result += billy[n];

}

cout << result;

return 0;

}

multidimensional array pseudo-multidimensional array #define WIDTH 5 #define HEIGHT 3 int jimmy [HEIGHT][WIDTH]; int n,m; int main () { for (n=0;n<HEIGHT;n++) for (m=0;m<WIDTH;m++) { jimmy[n][m]=(n+1)*(m+1); } return 0; } #define WIDTH 5 #define HEIGHT 3 int jimmy [HEIGHT * WIDTH]; int n,m; int main () { for (n=0;n<HEIGHT;n++) for (m=0;m<WIDTH;m++) { jimmy[n*WIDTH+m]=(n+1)*(m+1); } return 0; }

and now for trignometry

#include<iostream>

#include<cmath>

using namespace std;

int main()

{

int factorial(int);

int n = 3, i = 1;

double x, x2, b, PI, r;

char choice;

//r = x * (PI / 180)

cout<<"Please enter an angle value => ";

cin>>x;

cout<<"Is the angle value in Degree or Radian?"<<endl;

cout<<"Type D if its in degree "<<endl;

cout<<"Type R if its in radian "<<endl;

cin>>choice;

if((choice = 'R')||(choice = 'r'))

do{

i++; n = 3; x2 = 0; b = x2;

{

if(i == 1)

x2 = x - (pow(x,n) /factorial(n));

n = n + 2;

};

else

{

x2 = (x2 + ((pow(x,n)) /(factorial(n))) - (pow(x,n+2)) / (factorial(n+2)));

n = n + 4;

}

}while(abs(b - x2) > 0.000001);

else

//convert it to r

r = x * PI /180;

//cout<<"error occured/n";

cout<<"sin(x) = "<<x2<<endl;

return 0;

}

Mar 24, 2008 | ArcMedia JavaScript Source Code 3000 Pro...

Yes, there is a function in MS Excel called "sumproduct" which multiplies the componenets in an array or arrays, then totals the result, eg :

=SUMPRODUCT(D4:D20,B4:B20) ...Job done...Enjoy !

=SUMPRODUCT(D4:D20,B4:B20) ...Job done...Enjoy !

Jan 16, 2008 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

108 people viewed this question

Usually answered in minutes!

×