Hi

Not sure if this is the section to post in as I am looking for general advice to begin with and I will follow wherever it takes me.

I have an item which we buy in that is a finished item but 2nd hand so they can be complete or they can be missing parts or have broken parts. The reason will usually vary within a set of boundaries that rarely change.

The project I am looking to build and it may be way beyond my capabilities anyway is to design a spreadsheet or database or whatever that will allow me to enter an approximate sale price of the finished item and the purchase price and list any parts it may need.

As I buy a lot of these items, some without faults, some without, I am looking to work out whether it is better to order replacement parts at a set cost (which varies depending on the part(s) required) or whether it is better to strip one to repair the others which may have other defects.

It sounds as though it would use some complex conditional formatting.

I am open to ideas.

Thanks in anticipation.