disclaimer: noob that knows almost nothing about excel.
so, I'm working with a pretty massive data set. I wanted to increase the scale of an entire column by 100x, so I made a new column, H, and set the following H=I*100.
unfortunately, doing so enters a zero in the cell when the cells in the column I had no data. The value should not be 0, but should be blank. I'm running time-regressions and replacing '0' with '..' will work. I did this using an IF function in the past, but haven't been able to get it to work this go around.
Any suggestions?
NEVERMIND. Got it. did the following:
H109=IF(I109=0,"..",I109*100)
...now i just need to learn how to delete my pointless thread.
Bookmarks