ISBLANK function not working when cell is blank dut to functio
Did you see Dave P's reply?
If not, here are his suggestions.
=IF(A1="","SPARE","IN-USE")
or
=IF(trim(A1)="","SPARE","IN-USE")
Gord
On Sat, 21 Jun 2008 06:10:00 -0700, mcmilja
wrote:
Hello Gord,
Here is the formula I'm trying to use:
=IF(ISBLANK(A1),"SPARE","IN-USE")
A1 is blank but contains the following formula:
=IF(ISBLANK(VLOOKUP(X686,MTN_Xng_IPBH_ER01_Ports. xls!ER01_Xng_Path,4,FALSE)),VLOOKUP(X686,MTN_Xng_I PBH_ER01_Ports.xls!ER01_Xng_Path,5,FALSE),VLOOKUP( X686,MTN_Xng_IPBH_ER01_Ports.xls!ER01_Xng_Path,4,F ALSE) )
Thanks,
Jaret
"Gord Dibben" wrote:
The cell is not blank if it contains a formula returning "" so ISBLANK will
prove FALSE
There is no such thing as a NULL value if cell is not truly empty.
Suggestions..........? What do you want want to do with the cell?
Gord Dibben MS Excel MVP
On Fri, 20 Jun 2008 12:34:01 -0700, mcmilja
wrote:
Hello,
The ISBLANK function does not work for me when the cell it's refencing is
"blank" due to a function result. Does anyone have any suggestions?
Thanks,
Jaret
|