At 20/10/2002 01:31 PM, you wrote:

> /* This is my Excell formulas */
> =IF(M2>9,TRUNC((M2-MOD(M2,10))/10)+MOD(M2,10),M2)
>
>/** my SP *//
>IF (:D4 > 9) then
>D4 = SR_TRUNC((:D4-MOD(:D4,10))/10 + MOD(:D4,10),:D4); <<-- here I get the
>error.
>
>But if I do this I don't get the error but. the formula is not complete.
>
>IF (:D4 > 9) then
> D4 = SR_TRUNC(:D4-MOD(:D4,10))/10 + MOD(:D4,10); <<- Here I'm missing the
>las part of the excell fomula

The 3rd parameter of the Excel IF is the same as an ELSE clause.

Here's how the Excel formula would translate:

IF (:D4 > 9) THEN
D4=SR_TRUNC(:D4-MOD(:D4,10))/10 + MOD(:D4,10)
ELSE
D4=D4;


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)