O
OTWarrior via OfficeKB.com
I have collection of form fields, and I want 2 of them to do a calculation in
text3
Text 1 and text 2 are (numbered) editable text form fields, which the user
can put a number into, and text 3, is a calculation.
The fields are bookmarked as text1, text2 and text3
I have battled with this, and so far if i get text 3's calculation to be
"Text1" then it displays it, and the same with "text2". however, I want them
to be multiplied by each other and the result to be displayed in text 3.
like so:
text1: 2 text2: 5 text3: 10
However, when i put
=PRODUCT({Text1},{text2})
into the calculation box, all i get is "t"
text1:2 text2: 5 text3: t
I have tried other variations such as = product{text1,text2} to no prevail.
Am I not able to use bookmarks to do calculations here? as I have tried doing
the calculation in code (using a macro), but I cannot reference the bookmarks
in VB for some reason.
Any assistance would be much appreciated.
text3
Text 1 and text 2 are (numbered) editable text form fields, which the user
can put a number into, and text 3, is a calculation.
The fields are bookmarked as text1, text2 and text3
I have battled with this, and so far if i get text 3's calculation to be
"Text1" then it displays it, and the same with "text2". however, I want them
to be multiplied by each other and the result to be displayed in text 3.
like so:
text1: 2 text2: 5 text3: 10
However, when i put
=PRODUCT({Text1},{text2})
into the calculation box, all i get is "t"
text1:2 text2: 5 text3: t
I have tried other variations such as = product{text1,text2} to no prevail.
Am I not able to use bookmarks to do calculations here? as I have tried doing
the calculation in code (using a macro), but I cannot reference the bookmarks
in VB for some reason.
Any assistance would be much appreciated.