I've got thirty five cells in a row (sequential columns) with the answer
shown in the next colun.

I want the answer to show only when all previous cells are filled with a
value.

The narrative of the formula in col F would be along the lines of :

if ((A1 or B1 or C1 or D1 or E1.....etc = "") then "", otherwise calculate
the answer

Can SKS tell me what the excel formuale might be.

Tx

Robin