ExcelBanter - If Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statement (https://www.excelbanter.com/excel-discussion-misc-queries/203886-if-statement.html)

Rajula

If Statement

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

If Statement

Try this

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

Mike

"Rajula" wrote:

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

Rajula

If Statement

Thanksyou for this, it was helpful.

Rajula

"Mike H" wrote:

Try this

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

Mike

"Rajula" wrote:

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

All times are GMT +1. The time now is 12:05 AM.