A display panel needs at least eight mounting positions, with one dead center and the same number on each side. Eight satisfies the minimum but has no middle position. Nine satisfies both requirements.

Round the minimum with ODD

Put the positive minimum in A2 and enter this in B2:

=ODD(A2)

For a positive input, ODD returns the smallest odd integer at least as large as that input. Keep blanks, zero and negative counts out of this layout calculation.

The minimum of eight mounting positions rounds to nine for a panel with a center position.

Illustrated layout. The extra position makes the row symmetric.

Count the positions beside the middle

In C2, calculate how many positions are on each side:

=(B2-1)/2

For a minimum of 8, the outputs are 9 total and 4 per side. For a minimum of 9, the outputs stay the same. For 10, expect 11 total and 5 per side. Check that the actual panel can fit the rounded count before using the number to order materials.

A minimum of nine stays at nine, with four positions on each side.

Illustrated boundary check. Confirm an already odd count stays in place.

Microsoft’s Excel function reference