data in value = 1

[Peter Fitz]

I am inputting data into cells in row 1 to 31, b-g

what i need and its probably really simple, think im just

confusing my self.

I would like the cells in column h to show a value of 1 if data has been
entered in the cells on that row


Thanks

Peter

 

[VoG]

Try in H1

=IF(COUNTA(B1:G1)>0,1,"")

or

=IF(COUNTA(B1:G1)=6,1,"")

depending whether any entry is to be flagged with a 1 or all cells must be filled.

 

[Peter Fitz]

Thats brilliant thanks a lot