Use an if formula but ignore "blanks"

[jdhfch]

Hi,

I am trying to use an if function which I want it to populate a cell if the cell is not blank. The formula sees the cells that are "empty" as having content in, which I dont want.

The source cell formula is in cell N5274 =IFERROR(IF(L5272>0,VLOOKUP(F5272,List!A:A,1,FALSE)),""). This works ok

The formula I am trying to use in cell F5274 is =IF(E5274="Test",IF(N5274>0,1),0) - this doesnt work - it returns a 1 even in the cells that have returned a "" in N5274

Please can anyone help?

 

[Beneindias]

Just add a condition.

I think you just need to do this:

=IF(N5274="";"";IF(E5274="Test",IF(N5274>0,1),0))

This way, if cell N5274 is empty (" "), it will return a "".

If this is not it, just post a sample of your data, to help solving the problem

 

[Fluff]

How about

=IF(E5274="Test",IF(N5274<>"",1,0),0)

 

[jdhfch]

Just add a condition.

I think you just need to do this:

=IF(N5274="";"";IF(E5274="Test",IF(N5274>0,1),0))

This way, if cell N5274 is empty (" "), it will return a "".

If this is not it, just post a sample of your data, to help solving the problem

 

[jdhfch]

Excellent - thank you

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Beneindias]

You should mark the solution

Glad we could help