If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#DIV/0! in the array function
Hello,
I keep on receiving the #DIV/0! error in the following formula (BTW, Bob Phillips, thanks again for the hint): {=COVAR(IF((A2:A10--"01/01/2004")*(A2:A10--"31/10/2004"),B2:B10),IF((A2:A10--"01/01/2004")*(A2:A10--"31/10/2004"),C2:C10)} the cells A2:A10 contain dates and B2:C10 contain numbers (some of them are 0, but it isn't a problem). The problem is that I need to calculate the covarience over a specific range in the bigger table, so I have to use an array formula. Yet, whatever values I have, it gives me division by zero error. Is there a way I can fix this? or how can I trace an error? So far I realised that condition I have gives my FALSE results in any case, however this range does exist. Please help! My thesis deadline is approaching )) Thanks in advance, Sergiy |
#2
|
|||
|
|||
#DIV/0! in the array function
Sergiy,
Send me the workbook and I will take a look. -- HTH RP (remove nothere from the email address if mailing direct) "Sergun" wrote in message ... Hello, I keep on receiving the #DIV/0! error in the following formula (BTW, Bob Phillips, thanks again for the hint): {=COVAR(IF((A2:A10--"01/01/2004")*(A2:A10--"31/10/2004"),B2:B10),IF((A2:A1 0--"01/01/2004")*(A2:A10--"31/10/2004"),C2:C10)} the cells A2:A10 contain dates and B2:C10 contain numbers (some of them are 0, but it isn't a problem). The problem is that I need to calculate the covarience over a specific range in the bigger table, so I have to use an array formula. Yet, whatever values I have, it gives me division by zero error. Is there a way I can fix this? or how can I trace an error? So far I realised that condition I have gives my FALSE results in any case, however this range does exist. Please help! My thesis deadline is approaching )) Thanks in advance, Sergiy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please add an INTERPOLATE function. For vector or array data. | Dan Gauthier | Worksheet Functions | 15 | August 4th, 2009 01:48 PM |
Array Function Question | Henrik | Worksheet Functions | 1 | June 8th, 2005 02:24 AM |
Vlookups array function by Alan Beban | FWA | Worksheet Functions | 2 | February 17th, 2005 09:43 PM |
Array Functions | Alan Beban | Worksheet Functions | 11 | April 14th, 2004 07:06 AM |
Array Formula - Use of OFFSET function with array argument | Alan | Worksheet Functions | 2 | February 11th, 2004 09:38 PM |