Combination If Function

Hi Sam,

To give a bit of background is that I have a product and a customer has given us 5 different attachments that he is wanting to mount onto the product. Basically we have said that you cannot mount all of these on the product at the same time. So he has come back asking if we could provide a sheet which will demonstrate that if item 1, 2 and 3 are fixed will this work. or if Item 1, 3 and 5 are mounted will this work and so on...

I am yet to collate all the information but wanted to make sure and how it would be done before I start collating the information.

I have attached an excel spreadsheet which I have tried to simplify and I have given different scenarios to give a bit of context if that`s any use

Thanks