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

Options
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))

 

 

Capture.PNG

Tags:

Comments

  • ricki
    ricki ✭✭✭✭✭✭
    Options

    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!