ExcelBanter - IF formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF formula help (https://www.excelbanter.com/excel-worksheet-functions/262841-if-formula-help.html)

Mark D[_2_]

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

Jacob Skaria

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

MS-Exl-Learner

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

All times are GMT +1. The time now is 05:22 AM.