ABS function in complex formula

Ian Wakeling · Post by **Ian Wakeling** » 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.

Post by **larsa** » Wed Feb 21, 2007 7:38 pm

Hello

This is fixed in the latest update, 3.01.00

Lars Arvidsson

Ian Wakeling · Post by **Ian Wakeling** » Thu Feb 22, 2007 10:23 am

Thank you Lars.

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

Ian.

Guest · Post by **Guest** » 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))

Post by **larsa** » Fri Apr 27, 2007 5:45 am

Hello

Please check that you really is using the latest update.

Lars Arvidsson

Guest · Post by **Guest** » Fri Apr 27, 2007 11:32 am

Hello,

Get the latest update of link:

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

Guest · Post by **Guest** » Wed May 02, 2007 11:10 pm

Hello,

Help me!!!!

Cris

Post by **larsa** » Thu May 03, 2007 9:59 am

Hello

I can't reproduce this error.

Lars Arvidsson