Leaving a cell (with formula) displaying as empty if theres data in another cell

Hi,

If J6 is dependent on J7 and J7 is dependent on J6, which you seem to be suggesting then you're creating a circular reference and unless there are over-riding reasons so to do then you should avoid them.

I'm also puzzled by the use of the term cost since you seem to be building a character string of page counts in column J. I can't see where true 'costs' appear

Can you tell us what you're trying to achieve and perhaps create several examples in which you have manually added rge results you expect to see and tell us which are the results and which original data.

To be honest I think you may be creating a problem for yourself in not having a normalised database of records.

If the intention is to be able to price wedding albums for customers then personally I'd rethink the design otherwise I think you're overcomplicating this.
If you have the costs for various sizes, page counts, paper quality & thickness then the first thing to do is create some tables that contain these various cost elements and use these when selecting what the customer wants and building up a quote.

Thanks for the replies.
I've tried making a new spreadsheet based on advice and putting the pricing info in a table with a couple of examples of what im trying to achieve.

All i want to be able to do is put the info onto the customer details worksheet,
Book Size, Number of Pages and Paper Type.
The formula then takes the correct info from the table on worksheet 3 and puts the price in the cost cell.

The new spreadsheet is here-

Wedding Test 2.xlsx


Thanks again!! Stuart.