What is wrong with my nested IIF THEN ELSE statement?!

Allison Jones
Allison Jones ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I typically do not have issues with calculations - I am sure that this is a really stupid mistake I am making - but what I am doing wrong with this nested IIF THEN statement?!


iif ([Data Type] = "Income Statement" 

THEN iif([Data Type]="Net Sales" 

THEN [Value] else        "" END))






  • ricki
    ricki ✭✭✭✭✭✭

    I dont know much about iif or how it differs from if but i think the problem is your parenthesis. did you try the following?


    iif ([Data Type] = "Income Statement" )

    THEN iif([Data Type]="Net Sales" )

    THEN ( [Value] else        "" END)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!