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.

Top
#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
Hi,

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

Code:
STR(VAL([Test])*2)
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!

Benoit
_________________________
Knowledge is capital
http://twitter.com/benoitpotvin

Top