Returning a Blank in a IF THEN ELSE statement involving a list

Options
DanielU
DanielU
in Modeling

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

  • rob_marshall
    rob_marshall
    Answer ✓
    Options

    @DanielU

    Have you tried using BLANK?

    IF x AND y AND z

    THEN Values to lookup[LOOKUP: Mapping]

    ELSE BLANK

Answers

  • andrewtye
    andrewtye
    Options

    Hi @DanielU

    Unless am misunderstanding you all you need do is to do is put BLANK at the end and you'll get an empty cell - presumably what you're after?

  • Tiffany.Rice
    Tiffany.Rice
    Options

    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

  • DanielU
    DanielU
    Options

    Thanks all, this has worked!

Categories