| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to represent an empty cell in excel formulae?
The formula should work only when the cell has some value and should not take
the emptyness as zero value. Is there a way where by an empty cell can be represented or is there any other way to activate the formula only when cell has some value. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to represent an empty cell in excel formulae?
A number of ways
=ISBLANK(A1) =A1="" both these will be false if A1 has a formula in it. =LEN(A1)=0 this will return true if there is a formula returning "" -- HTH Bob Phillips "Sibi Melvin" <Sibi wrote in message ... The formula should work only when the cell has some value and should not take the emptyness as zero value. Is there a way where by an empty cell can be represented or is there any other way to activate the formula only when cell has some value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the cells that represent a code in one cell | Excel Worksheet Functions | |||
| How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
| What does the 8.43 and 12.75 represent in height and width of cell | Excel Discussion (Misc queries) | |||
| How to represent an empty cell in excel formulae? | Excel Worksheet Functions | |||
| How do I represent data in a cell as hexadecimal without converti. | Excel Discussion (Misc queries) | |||
Hybrid Mode
