Dynamic mattress/bed Questions
-
Hi
I’m trying to create a dynamic mattress/bed and have two questions about how to do this.1, select the size of the mattress from a drop down menu and have both the X & Y dimensions change.
2, when a single is selected have one pillow in the middle and on a double have 2 at ¼ and ¾ along the bed.
If anyone knows where I can find a good tutorial on creating dynamic components it would be appreciated.
Thank you for your help.
-
-
Thanks juju
The information it will be of use to me, especially when I try a dynamic staircase.
I've managed to solve the second question, I was trying to use one component with 2 pillows but realized two components one with 2 pillows and a single pillow components with them being hidden as required.
I'm still struggling with my first question, I tried the formula below
=IF(Size= [highlight=#ff4040:wwqhhw6a]King OR Super King[/highlight:wwqhhw6a],200,190)
I didn't work and only solves the problem if there are two lengths to chose from.
Andrew
-
OR(logicalValue1,logicalValue2,...logicalValueN)
so quite likely
=IF(or(Size = "King", Size = "Super King"),200,190)
-
Hi pcmoor
Thanks for the reply your formula worked but I did have to change the descriptive values for the actual width values of the mattress size
=IF(or(Size = "150", Size = "180"),200,190)
I also now know that I cant Just stick AND & OR any where I Like I've got to put them in first.
Advertisement