| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Checking if a cell is filled up with data
Hi! I would like to write a function that checks if a cell is empty or if it has any kind of data. The kind of datas (numbers or words or bocth) is irrelevant. The only thing that is important is whether or not the cell is empty. Has anyone an idea how I could write such a function? Thanks -- xpucto ------------------------------------------------------------------------ xpucto's Profile: http://www.excelforum.com/member.php...o&userid=23748 View this thread: http://www.excelforum.com/showthread...hreadid=374119 |
|
#2
|
|||
|
|||
|
=IF(A1="","",A1) Enter this formula in cell B1. If A1 is empty, then B1 will be empty, else it will put the value of A1 in B1 Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=374119 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
| how do i reference data in a file with the fname in another cell? | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Import Data into same cell | Excel Discussion (Misc queries) | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
Hybrid Mode
