Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IF

Hi trying to create    =IF(table[ordertypeD] = "Normal Order"), table[feild],"")   Getting an error on "Normal Order"  Yet Normal Order exists in table[ordertypeD]   In fact I get an error as ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Try

    =IF(table[ordertypeD] = "Normal Order", table[feild],blank())

Tahreem24's avatar
Tahreem24
Super User
5 years ago

Anonymous ,

There is an Parenthesis error. It should be like:

=IF(table[ordertypeD] = "Normal Order", table[feild],"")