In the attached, I want the user to enter length and width data. For each length and width, there are a number of bays. L and W are divided by their respective bay no. So in the example, length =4800 and bays = 2. Output in cell F7 = 2400. In column U, I only i want to see L1 L2 entries, as ultimately i am plotting this data and will suppress the zeros hopefully. I was trying to work out how to do this and came up with (perhaps not the nicest of solutions!):-
The issue I have, is L1 to L6 are all displaying values? I thought the logic looked OK. Only value that works is 1 for bay.
Thanks in advance Paul