Axolot Data

Posted: **Wed Feb 14, 2007 11:10 am**

I am trying to use the ABS function in a cell formula that looks like:

IF(ABS(0.005+OFFSET(A1,1,15+B9))>OFFSET(C20,B9,0),OFFSET(A1,1,11),NA())

However, I am getting an exception from EncodeFormulaII2 that tells me "wrong number of arguments for function ABS".

Any thoughts on a work around?

Thanks,

Ian.

Posted: **Wed Feb 21, 2007 7:38 pm**

Hello

This is fixed in the latest update, 3.01.00

Lars Arvidsson

Posted: **Thu Feb 22, 2007 10:23 am**

Thank you Lars.

I have tested the with the new version and no more exceptions.

Ian.

Posted: **Thu Apr 26, 2007 5:34 pm**

Hello,

This same problem occur with me ("wrong number of arguments for function ABS"), but I'm using a version 3.01.01 and is occur on unit XLSFuncEval2 and I'm using the formula -> (valor_411-ABS(valor_412))

Posted: **Fri Apr 27, 2007 5:45 am**

Hello

Please check that you really is using the latest update.

Lars Arvidsson

Posted: **Fri Apr 27, 2007 11:32 am**

Hello,

Get the latest update of link:

http://www.axolot.com/components/f_downloadreg.htm

Posted: **Wed May 02, 2007 11:10 pm**

Hello,

Help me!!!!

Cris

Posted: **Thu May 03, 2007 9:59 am**

Hello

I can't reproduce this error.

Lars Arvidsson

Axolot Data

ABS function in complex formula

ABS function in complex formula