If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF formula help
Hi Again everyone.
Ok another problem I am now having. I have the following formula in column H =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April 2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'C urrent running April 2010'!$1:$65536,1,FALSE)) In Column I simply want to say =IF(ISBLANK(h9),"","yes") But it's returning yes even if the cell is blank. Any ideas? Thanks |
#2
|
|||
|
|||
IF formula help
ISBLANK() validates only truly blank cells and not the ones having formulas....
=IF(H9="","","yes") -- Jacob (MVP - Excel) "Mark D" wrote: Hi Again everyone. Ok another problem I am now having. I have the following formula in column H =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April 2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'C urrent running April 2010'!$1:$65536,1,FALSE)) In Column I simply want to say =IF(ISBLANK(h9),"","yes") But it's returning yes even if the cell is blank. Any ideas? Thanks |
#3
|
|||
|
|||
IF formula help
Because the H9 cell is not a blank cell and it will be having any formula on
it. Try this… =IF(LEN(H9)=0,"","Yes") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Mark D" wrote: Hi Again everyone. Ok another problem I am now having. I have the following formula in column H =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April 2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'C urrent running April 2010'!$1:$65536,1,FALSE)) In Column I simply want to say =IF(ISBLANK(h9),"","yes") But it's returning yes even if the cell is blank. Any ideas? Thanks |
Thread Tools | |
Display Modes | |
|
|