View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz[_2_] Maury Markowitz[_2_] is offline
external usenet poster
 
Posts: 119
Default Odd formatting issue

I'm sure this is a no-brainer...

I have a bunch of read-only columns way over on the right of a sheet.
I use formulas to copy that into the visible portion on the left. One
of the formulas is...

=IF(CB20=1,CI20,"")

This works in many cases, but if CI20 is "" (ISBLANK returns TRUE)
then the value is "0". Why is this, and how do I get a blank here
instead?

Maury