| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
