How do I multiply

Posted by: Jpizzle

How do I multiply - 06/09/10 01:45 PM

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.
Posted by: Anonymous

Re: How do I multiply - 06/25/10 04:33 PM

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