02-10-2012 02:00 PM
I know this must have been answered somewhere, but I can't find it ...
I would like to write a formula to Excel rather than a value. I know I can write like: '=ROUND(+RC[-1],2)' but I would like to just write a simple ' =B1/B4' into the sheet. When I try this, Excel wraps a bunch of quotes around the value and it becomes garbage.
Thanks in advance.
02-10-2012 02:22 PM
If you are using the excelxp tagset according to this note you may have to state it in relative terms: http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html
Thus, if it is going in column 5, you may have to state it like your round formua: =RC[-4]/RC[-1]