ERR:509 - ERROR IN OPEN OFFICE ver 3

philippeabe · Newbie Joined: 25 Jun 2012 Posts: 1

=$Sheet3.$AD$97:AD97($Sheet3.$AD$97:$AD$185;MATCH(REPT("Z";255);$Sheet3.$AD$97:$AD$185))

=iferror(INDEX(nn;MATCH(0;COUNTIF(nn;"<"&nn)-SUM(COUNTIF(nn;$U$96:U96));0));"")

showing error - Err:509 for above formula....

But it was working much fine without any prob in EXCEL. - But problem exsists in OPENOFFICE. I'M USING OO VER3

PLEASE MAIL ME TO MY EMAIL ID abraham@covenantindia.net / philippeabe@gmail.com FOR SOLUTION

I LL BE THANKFULL TO U SO MUCH IF YOU HELP IN THIS...
_________________
PHILIPPE ABRAHAM

Villeroy · Posted: Mon Jun 25, 2012 6:47 am Post subject:

Thank you for exposing your mail address to the spammers. This way a tiny fraction of the world wide spam flood may be kept within India.
This is a forum on a web-site. Nobody will answer by mail.

iferror is not a Calc function. There is IF and there is ISERROR. You can combine these like you would do in Excel XP.
=IF(ISERROR(...) ; "" ; ... )
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org