IF Formula based on a Cell containing a formula

[Liam2003]

Hi there,

I am trying to create this formula =IF(Q11>0,1,AK11) however it appears not to work?

Q11 contains a formula {=IFERROR(INDEX(lastsaledatacust,MATCH(1,IF(lastsalecust=$D$5,IF(lastsaleprodcust=$C11,1)),0),5),"")}

AK11 contains a Data Validation drop down box

Please help

Thank you.

 

[Liam2003]

Hi there,

I am trying to create this formula in cell AL11 =IF(Q11>0,1,AK11) however it appears not to work?

The following 2 cells within this formula, these are working perfectly, just the above mentioned formula!
Q11 contains a formula {=IFERROR(INDEX(lastsaledatacust,MATCH(1,IF(lastsalecust=$D$5,IF(lastsaleprodcust=$C11,1)),0),5),"")}

AK11 contains a Data Validation drop down box

Please help

Thank you.

 

[PaddyD]

what does:

=isnumber(q11)

return?

 

[Liam2003]

Hi there,

Returns. TRUE

what does:

=isnumber(q11)

return?

 

[Liam2003]

It returns TRUE.

Thank you