Thanks, I do have more materials to choose from and was looking for a way to keep the values with the name of the materials

This is much cleaner, but like you said, I ned to keep an eye on material and value orders

Hi All,

Sorry if this has been covered, I have searched, but not been able to find anything.

I am building a dynamic component library of items I use regularly, for example, I use 100mm high flooring with various floor finishes.

Now I am having trouble with my IF formulas for multiple material selection

I have entered the following formula under a custom attribute called "Top_Floor_Cost":

=if(Material="Color_000", 60), if(Material="Carpet_Plush_Charcoal", 70), if(Material="Wood_Floor_Parquet", 75)

Now when I select the appropriate floor covering (eg. "Carpet_Plush_Charcoal" from the drop down menu in the Component Options widow, Nothing shows in the Top Floor Cost box, but, In the component Attributes Window, I see #=,70, So the Formula works, but wont translate to the Options window

Can anyone shed any light on the correct syntax for multiple options on the IF formula?

Thanks