copying by formula....
 

Hi Alex

You seem to be using semicolon as your separator, apart from the final
term where you are using a comma

*100,"-")

--
Regards

Roger Govier


"Alex" wrote in message
...
Hello

I use the result of several column to compute a value in another
column with
some conditions but it doesn't work. The fomula seems to be wrong but
I don't
know where.

TargetWorkSheet.Cells(RowWhereToWrite, ColumnWhereToWrite).FormulaR1C1
=IF(AND((int(RC[-5])-int(RC[-2]))<0;INT(RC[-6])<
1;INT(RC[-1])=0;INT(RC[-2])=0),RC[-5]/(RC[-5]-RC[-2])*100,"-")

Thank you