IFS and CONTAINS

[Gardener76]

Hi 

I am trying to to put a price in a column, based on another column [Panel] containing certain codes.  But not working. Advice where I am going wrong on this would be appreciated. Thanks in advance.

IFS([Panel] CONTAINS("CMM40"),"25.50", CONTAINS("CMM101"), "21.50", CONTAINS ("CMW102"), "28.50")

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2347639-contains

[Gardener76]

thanks Bro, just seen where I have gone wrong.... Thank you