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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have in D5:

IF(a2>0,c$2,"")

where:

A2 is a formula: =if(a1>0,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
 
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
 
Back
Top