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?
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?