B bctyner New Member Nov 8, 2011 #1 Hello, Previously I wrote a formula that wrote "" if below a certain value. Then I copied the output as text. Now I want to make that column have 0s instead of blank cells. I tried an IF statement with the value if false as 0, but no luck. Any suggestions?
Hello, Previously I wrote a formula that wrote "" if below a certain value. Then I copied the output as text. Now I want to make that column have 0s instead of blank cells. I tried an IF statement with the value if false as 0, but no luck. Any suggestions?
B bctyner New Member Nov 8, 2011 #3 =IF(N3>0, N3, 0) The blank cells remain blank, and should be 0. Thanks again.
B bctyner New Member Nov 8, 2011 #4 I pretty much did the reverse of what I did before. =IF(N3="",0,N3) did what I needed. Thanks, though.
I pretty much did the reverse of what I did before. =IF(N3="",0,N3) did what I needed. Thanks, though.
