Log In
Register
Home
October 12, 2021
Offline
Hello - Is it possible to create multiple if List.Contains?
I'm trying to create a rather large custom column with IFs ORs and ANDs...
if [Space] = "A" or [Space] = "B" or [Space] = "C" or [Space] = "D" or [Space] = "E" or [Space] = "G" or [Space] = "H" or [Space] = "I" or [Space] = "J" or [Space] = "K" or [Space] = "M" or [Space] = "N" or [Space] = "O" or [Space] = "P" or [Space] = "Q" or [Space] = "R" or [Space] = "S"and [Grade] >="9 (G9)" & [Grade] <="11 (G11)" then "$500" else if [Space] = "A" or [Space] = "B" or [Space] = "C" or [Space] = "D" or [Space] = "G" or [Space] = "H" or [Space] = "I" or [Space] = "J" or [Space] = "K" or [Space] = "M" or [Space] = "N" or [Space] = "O" or [Space] = "P" or [Space] = "Q" or [Space] = "R" or [Space] = "S" and [Grade] >="12 (G12)" and [Grade] <="14 (G14)" then "$750" else if [Space] = "A" or [Space] = "B" or [Space] = "C" or [Space] = "D" or [Space] = "G" or [Space] = "H" or [Space] = "I" or [Space] = "J" or [Space] = "K" or [Space] = "M" or [Space] = "N" or [Space] = "P" or [Space] = "Q" and [Grade] >="15 (G15)" and [Grade] <="17 (G17)" then "$1250" else ""
July 16, 2010
Offline
Hi Jennifer,
Better to use a lookup (merge tables): https://www.myonlinetraininghu.....ry-vlookup
Or you can use List Functions: https://www.myonlinetraininghu.....-functions
Or if it's an approximate match: https://www.myonlinetraininghu.....ch-vlookup
Mynda
1 Guest(s)
