=IF(COUNTA(A1:AI1)=35,"ok","not ok")

--
HTH

Bob Phillips

"RFJ" wrote in message
...
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