Solver Cloud Integrations support standard Excel If statement structure for simple logic.  For example:

IF([LOCATIONID]=”,’NONE’,[LOCATIONID])

is supported.  However, for more complicated If statements, log into Solver Support and use syntax described in this support article.  As mentioned in the article, Solver integrations do not support major or complex data transformations and it’s a better practice to pre-stage data in the source system whenever possible.