Feedback by UserVoice

Stevenson Yu

My feedback

  1. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stevenson Yu shared this idea  · 
  2. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stevenson Yu shared this idea  · 
  3. 120 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Stevenson Yu commented  · 

    @kalecka: It won't. The formula will simply return LongFormula for all FALSE values.

    For example:

    IF(LongFormula="","",IF(LongFormula>=B3,"Not Applicable",LongFormula))

    will just become

    IFX(LongFormula,"","",">="&B3,"Not Applicable")

    An error occurred while saving the comment
    Stevenson Yu commented  · 

    After mulling it over, I propose a slight correction to Carole's proposal.

    Since condition 2 and thereafter are optional, this should be implemented just like the plural version of the arithmetic IF functions.

    IFX(LongFormula, Condition1, Value if True, Condition2, Value if True, ... ConditionN, Value if True)

    An error occurred while saving the comment
    Stevenson Yu commented  · 

    I want this formula. It will likely result in more efficiency since you only need to evaluate LongFormula once instead of twice.

    Stevenson Yu supported this idea  · 

Feedback and Knowledge Base