Returning a Blank in a IF THEN ELSE statement involving a list
Hi,
I am looking for a way to return a blank for an IF THEN ELSE formula involving a list:
IF x AND y AND z
THEN Values to lookup[LOOKUP: Mapping]
ELSE Return a Blank
The Return a Blank part is what I am having an issue with. I can't use 0 or "Null" as the format of the line item is a list, is there a way to return a blank without adding a list item?
Any assistance would be appreciated, let me know if you have any questions 🙂
Many thanks,
Daniel
Best Answer
-
Have you tried using BLANK?
IF x AND y AND z
THEN Values to lookup[LOOKUP: Mapping]
ELSE BLANK
0
Answers
-
Daniel, you are so close you can taste it! "BLANK" is the syntax to return a null value for a list formatted line item.
So in your example that would be:
IF x AND y AND z
THEN Values to lookup[LOOKUP: Mapping]
ELSE BLANK
0 -
Thanks all, this has worked!
1