123 Err formula

[anthonyenglish]

Hi, I've been asked to convert a load of old 123 files and found a formula that I'm not sure of. 123 has a function called Err. Looking at the help available, it's used to generate an error

Err : Returns an illegal value interpreted as ERRor.
For example, using the IF function, the formula =IF(G12<3,ERR,B2) returns ERR if the contents of G 12 are less than 3 and returns the contents of B2 otherwise. This can then be tested with the ISERR function.

I get how that works. But does anybody know that this is doing?

+ERR/@IF(H12="M",12,1)

or better still this....

@IF(@ISNUMBER(ERR),@IF(ERR="Y","rate of ","")&ERR&"% per annum","Retail Price Index"&@IF(ERR="LPI",", subject to a maximum of 5% per annum.","."))

I've literally no idea what these are trying to do!

Regards,

Tony

 

[RoryA]

ERR is an error value, not a function. @ERR() is the function. It looks to me like your formulas are broken as they make no sense to me.

 

[anthonyenglish]

Hi its a 123 formula. As I said in the opening thread, @Err returns an error but I agree the formulas make no sense. My thinking is that they are no longer used as these are old workbooks.

 

[RoryA]

I know it’s 123. My point is that ERR, as in your formulas, is not a function, it’s an error value. That’s why the formulas make no sense.

 

[anthonyenglish]

Hi - I get what you are saying now - you mean the equivalent to an Excel #Ref. To test it out I did a simple test. 2 values in 2 cells and added them up and then deleted one of the cells by deleting the column and the formula changed to +ERR+b2....So it looks like you were right. I'd assumed because these files were supposed to be live files (after only 30 or 40 years of use) that there shouldn't be any broken parts to them....looks like that wasn't a good assumption. Thanks for pointing me in the right direction

 

[RoryA]

you mean the equivalent to an Excel #Ref

Yep, exactly that. If you see that in the formula bar, you know something isn't right.