Filling Cells With 1 or Nothing

[sm2200]

I have a vertical column of 100 cells. Assume it is Column S and the cells are from S1 to S100. The top cells in column S will have a number in them and the rest will be blank . In column T , cells T1 to T100, I wish to place a formula that will have a 1 appear in the cell if there is a number in the adjoining cell in column S and be blank if the adjoining cell in column S is blank. I tried the following fomula in cell T1 and copied it down in the rest of the cells in column T, but it didn't work. The formula I put in T1 was ;
=IF(S1=" "," ",1) How should I solve my problem.
Thanks,
Sam Marx

Please disregard the question at the end regarding ACN

 

[Steve=True]

try to do one of the following

Remove the space in your forulas between the quotes. Space is not blank

so do 2 quotes together.

2nd, you can change your formula to:

IF(isblan(S1),"",1)