B1 to B100 has a formula in it which displays a number in some cells and nothing in others
I want to use the following formula in C1 - C100
If(B1>0,Y,N) then fill down
however I get Y in every cell
How can I treat any cells in column B that show nothing as blank
Thanks
Bookmarks