How do I multiply - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

You are not logged in. [Log In] Objectif Lune » Forums » PrintShop Mail 6 » Expressions, Functions and Databases » How do I multiply

Topic Options

#24742 - 06/09/10 01:45 PM How do I multiply
Jpizzle 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
Anonymous Unregistered	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
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, OL Newsgroup Support, OL Newsgroup Training, Raphael Lalonde Lefebvre