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.

Hi,

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!

Benoit