Topic Options
#24742 - 06/09/10 01:45 PM How do I multiply
Jpizzle Offline
OL Newbie

Registered: 02/12/10
Posts: 9
Loc: USA
I am given a number in an Excel spreadsheet that represents a dollar amount. I am being asked to multiply by 1.5 for one amount and by 2 for another.

How do I do this.

Thanks in advance for your help.

#24743 - 06/25/10 04:33 PM Re: How do I multiply
Benoit Potvin Offline
OL Expert

Registered: 01/02/08
Posts: 490
Loc: Montréal, Canada

Assuming the number is given in an Excel Field named 'Test', a PSM expression displaying the double of this amount could look like:

i.e. convert [test] into a number (with VAL), then multiply it by 2 (with *), then reconvert the result back into a string (with STR) so that it can be displayed on the page.

Hope this helps!

Knowledge is capital