AnsweredAssumed Answered

Using IF function for partial text

Question asked by pabloprat on Aug 22, 2018
Latest reply on Aug 22, 2018 by pabloprat

Hi,

I have one field that contains codes that look like this TTP125987,  CDR012, and so on... and another with brands like  DELL, IBM, APPLE, etc. and I want a new field with a description based on brand and model BUT if the code has the letters TTP, I don´t want the description to include the brand for that code and place XX instead of the brand and the model, but I can´t get my calculation to work as follows because it always includes the code:

If(SKU_code="TTP"; "XX" ; item_brand) & item_model

 

What it should show is XX followed by the model if the code includes TTP and if it doesn´t it should include the brand and model.

 

any ideas ?? thanks in advanced for your help.

Outcomes