Implementing Arrays in Excel

One of the key things in the excel is to compare/find the values in an array....when we specify a range in any function, the excel needs to be intimated that whether we are pointing at a single cell or an array. For example, I am checking that if a single cell is having 0 or not :

If(B1:b10=0,True,False)...Suppose if I have entered the farmulae in C5....it will check if the value in B5 is 0 or not...but if we want this farmulae to check if every cell in the range b1:b10 is 0 or not....we will have to tell excel to use the range as array..for that after putting the farmulae, press ctrl+Shift+Enter rather than the traditional Enter...

Want to know more about Excel. Here are some links given by my frnd OldChippy from Excelforum.com(The Maximum Knowledge Forum)


http://www.ozgrid.com/Excel/arrays.htm
http://www.emailoffice.com/excel/arrays-bobumlas.html
http://www.personal-computer-tutor.c...ayformulas.htm
http://www.excel-vba.com/excel-27-array-formulas.htm

Thanks,
Vikas B