If Statement

[Rajula]

If statement

If in a range of cells there is any blank cell, it should return the value
in a particular cell.

For Eg

A B C D E F G
Xyz Local 1.59 1.46 0.75 1.29

If in the range A1:G1 there is a blank cell, then it should return A1. Ie it
should return Xyz.

Any help is appreciated.

Thanks
Rajula

 

[Mike H]

Try this

=IF(COUNTA(A1:G1)<7,"",A1)

Mike

 

[Rajula]

Thanksyou for this, it was helpful.

Rajula

Try this

=IF(COUNTA(A1:G1)<7,"",A1)

Mike