NESTED IF STATEMENTS - 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 Suite 7 » PrintShop Mail Design » NESTED IF STATEMENTS

Topic Options

#39384 - 04/26/12 11:55 AM NESTED IF STATEMENTS
DeanB OL Toddler Registered: 04/05/12 Posts: 37 Loc: Harrogate, UK	Hi, I need an IF statement that will find three different company names in a column and not display a persons name if they come across them... i.e. IF ([company]="A" or "B" or "C", "", [persons name]) I tried 3 different variables (3 x separate IF statements) within an expression, i.e. IF @a@, @b@, @c@, "", [Persons Name] but neither of these items work, is there an easy work around?
Top

#39386 - 04/26/12 12:51 PM Re: NESTED IF STATEMENTS [Re: DeanB]
Marc-André Unregistered	Hi Dean, I want to make sure I understand this correctly. If in company the value is A or B or C you don't want to display anything and if it's something else you want to display [persons name] right? If so you were very close - but here is the proper syntax. IF ([company]="A" OR [company]= "B" OR [company]="C", "", [persons name])
Top

#39397 - 04/27/12 03:17 AM Re: NESTED IF STATEMENTS [Re: ]
DeanB OL Toddler Registered: 04/05/12 Posts: 37 Loc: Harrogate, UK	Brilliant - that works a treat, thanks very much!
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, Jean-Cédric, OL Newsgroup Support, OL Newsgroup Training, Philippe F., Raphael Lalonde Lefebvre