| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
testing the value of a cell
Curious what the code should look like to test if a cell
is empty of both numbers and letters. Trying to setup so that If B1 is empty then this else this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
testing the value of a cell
=IF(A1="", "A1 is empty", "A1 is not empty")
Dan E "Zeraia" wrote in message ... Curious what the code should look like to test if a cell is empty of both numbers and letters. Trying to setup so that If B1 is empty then this else this. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
testing the value of a cell
=ISBLANK(A3) where A3 is the cell being tested.
Zeraia wrote: Curious what the code should look like to test if a cell is empty of both numbers and letters. Trying to setup so that If B1 is empty then this else this. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
testing the value of a cell
If isempty(range("B1")) then
' this else ' that End if -- Regards, Tom Ogilvy Zeraia wrote in message ... Curious what the code should look like to test if a cell is empty of both numbers and letters. Trying to setup so that If B1 is empty then this else this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| testing for a value in a cell | Excel Discussion (Misc queries) | |||
| Testing cell value for greater than 0 | Excel Worksheet Functions | |||
| Testing a cell value | Excel Worksheet Functions | |||
| Testing positions in a cell | Excel Discussion (Misc queries) | |||
| Testing cell values... | Excel Programming | |||
Hybrid Mode
