Skip to main content

IF MANY question

  • January 10, 2019
  • 2 replies
  • 30 views

Forum|alt.badge.img+4

I’m using the following formula to take a value from a single select field {Products} and store a code.

IF(
	{Products}='Example Product',
	'EP',
	IF(
		{Products}='Example Lite',
		'EL',
		IF(
			{Products}='Example Any',
			'EA',
			IF(
				{Products}='Some Ref',
				'SR',
				IF(
					{Products}='Some Cloud',
					'SC',
					IF(
						{Products}='Any Sample',
						'AS',
						IF(
							{Products}='Good Sample',
							'GS',
							IF(
								{Products}='Part Pro',
								'PP',
								IF(
									{Products}='Example Reg',
									'ER'
									)
								)
							)
						)
					)
				)
			)
		)
	)

I need to change the {Products} field from a single select to a multi select and therefore allow multiple products. The formula should store one or more product codes. Is it possible to adapt the formula to support that? Many thanks!

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+18
IF(
   FIND('Example Product',Products)
   'EP'
) &
IF(
   FIND('Example Lite',Products)
   'EL'
) &
IF(
   FIND('Example Any',Products)
   'EA'
) &
etc...

Forum|alt.badge.img+4
  • Author
  • Known Participant
  • January 10, 2019
IF(
   FIND('Example Product',Products)
   'EP'
) &
IF(
   FIND('Example Lite',Products)
   'EL'
) &
IF(
   FIND('Example Any',Products)
   'EA'
) &
etc...

Thanks @Jeremy_Oglesby