if and countif problem

[plettieri]

All

the formula builder shows "-" which is a different result than which appears in the cell A5. The result in cell A5 displays 0, the result needed in "-"

=IF(A5>0,COUNTIF(all_borders,A5),"-")


....am I missing something here?

Thanks for looking.

plettieri

 

[Fluff]

If the formula is in A5 then you have a circular reference, which is why you get 0.
Try putting the formula in a different cell.

 

[plettieri]

Ya, I see it now...I must have been still sleeping when I drafted this...Thanks

 

[Fluff]

You're welcome & thanks for the feedback.