IF function...cell ref is a formula so True is retd when False sh
 

I have in D5:

IF(a20,c$2,"")

whe

A2 is a formula: =if(a10,vlookup(a1,ARRAY,2,false),"")
A1 is a part # (numeric)

So if A1 is left blank, A2 should remain blank (""), and D5 should return a
blank cell (""). But it doesn't work and I get C$2 in D5. Is this because
the formula is reading another formula in cell A2 rather than a value?
Should I be using a different formula altogether?

Thanks for any help!!

Alison

IF function...cell ref is a formula so True is retd when False sh
 

Never mind - I found a way around it (probably not the easiest but it works)
- I just rearranged my IF formula so that IF(A2="","",c$2) and it works!
Thanks....Alison

"Alison" wrote:

I have in D5:

IF(a20,c$2,"")

whe

A2 is a formula: =if(a10,vlookup(a1,ARRAY,2,false),"")
A1 is a part # (numeric)

So if A1 is left blank, A2 should remain blank (""), and D5 should return a
blank cell (""). But it doesn't work and I get C$2 in D5. Is this because
the formula is reading another formula in cell A2 rather than a value?
Should I be using a different formula altogether?

Thanks for any help!!

Alison