subtraction (in cells)

66 views
Skip to first unread message

timepro timesheet

unread,
Dec 28, 2021, 5:04:17 AM12/28/21
to
in xcel, how to syntax:

osheet:cells(12,3):value:=str((cell(3,16)-cell(5,14))*cell(19,22),14,3)

thanks

poopall

unread,
Dec 29, 2021, 8:49:05 PM12/29/21
to
oSheet:Cells( 12, 3 ):Formula = "+P3-(N5*V19)"

The formula needs to be a string that looks identical to the way you would write it in Excel Cell


Message has been deleted

timepro timesheet

unread,
Jan 1, 2022, 4:14:27 AMJan 1
to
thanks poopall:

*how do define/syntax a variable in 'sum' or 'formula'

code:
AGSSTAX=(netttax/currentsales)-commission && (almost always 18.00)
oSheet:cells(T16):value="=(sum("+"P16"+")"+"-sum("+"Q16"))"+"*3"+"-sum("+"R16+")"+"/AGSSTAX"

output:
T16 cell shows =(SUM(P16)-SUM(Q16))*3-SUM(R16)/AGSSTAX

does not convert 'agsttax' to it's value (for every cell agsstax value may be different/same)
(even :formula="P... shows 'agsstax' as a string not the value)


Reply all
Reply to author
Forward
0 new messages