Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Formula - Please help | Excel Discussion (Misc queries) | |||
Copying Formula | Excel Worksheet Functions | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
Copying Formula | Excel Discussion (Misc queries) |