hi,
use ISERROR for any version
On Jan 11, 2011 7:41am, Dave Bonallack wrote:
Hi,
If you are using xl2007 or more, you can use the IFERROR function.
In your case, I think the syntax would go something like this:
=IFERROR(INDIRECT(A1&"D$65")*1,"Linked Workbook not open!")
But I do
Hi All,
from my side.
=INT()
On Jan 13, 2011 9:04pm, kiran Kancharla wrote:
Hi All,
from my side I am adding 2 formulas.
1.Index
2.Match
One of the best functions..
Please have a look on the Attachment..
Thanks & Regards,
Kiran
On Thu, Jan 13, 2011 at