• excel: syntax for using a dynamic variable in SUM

    From timepro timesheet@21:1/5 to All on Mon Jul 18 04:07:35 2022
    *how to syntax a dynamic variable (THETAXPERC) in 'sum'
    for jc=nstart to xrow
    xvar1="P"+alltrim(str(jc));xvar2="Q"+alltrim(str(jc)) oSheet:cells(jc,21):value="=sum("+xvar1+"+"+xvar2+"/"+THETAXPERC")"
    next

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From poopall@21:1/5 to timec...@gmail.com on Wed Aug 10 16:19:59 2022
    On Monday, 18 July 2022 at 9:07:37 pm UTC+10, timec...@gmail.com wrote:
    *how to syntax a dynamic variable (THETAXPERC) in 'sum'
    for jc=nstart to xrow
    xvar1="P"+alltrim(str(jc));xvar2="Q"+alltrim(str(jc)) oSheet:cells(jc,21):value="=sum("+xvar1+"+"+xvar2+"/"+THETAXPERC")"
    next

    Can you send a small example of the spreadsheet you are using

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)