topic EXCELXP Formulas in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/EXCELXP-Formulas/m-p/51778#M6554 <HTML><HEAD></HEAD><BODY><P>If you are using the excelxp tagset according to this note you may have to state it in relative terms: <A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html</A></P><P></P><P>Thus, if it is going in column 5, you may have to state it like your round formua: =RC[-4]/RC[-1]</P></BODY></HTML> Fri, 10 Feb 2012 19:22:43 GMT art297 2012-02-10T19:22:43Z EXCELXP Formulas https://communities.sas.com/t5/ODS-and-Base-Reporting/EXCELXP-Formulas/m-p/51777#M6553 <HTML><HEAD></HEAD><BODY><P>Hi All:</P><P></P><P>I know this must have been answered somewhere, but I can't find it ...</P><P></P><P>I would like to write a formula to Excel rather than a value.&nbsp; I know I can write like:&nbsp; '=ROUND(+RC[-1],2)'&nbsp; but I would like to just write a simple ' =B1/B4'&nbsp; into the sheet.&nbsp; When I try this, Excel wraps a bunch of quotes around the value and it becomes garbage.&nbsp; </P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 10 Feb 2012 19:00:03 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/EXCELXP-Formulas/m-p/51777#M6553 OS2Rules 2012-02-10T19:00:03Z EXCELXP Formulas https://communities.sas.com/t5/ODS-and-Base-Reporting/EXCELXP-Formulas/m-p/51778#M6554 <HTML><HEAD></HEAD><BODY><P>If you are using the excelxp tagset according to this note you may have to state it in relative terms: <A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html</A></P><P></P><P>Thus, if it is going in column 5, you may have to state it like your round formua: =RC[-4]/RC[-1]</P></BODY></HTML> Fri, 10 Feb 2012 19:22:43 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/EXCELXP-Formulas/m-p/51778#M6554 art297 2012-02-10T19:22:43Z