I want this cell to show "N" if it's empty. But obviously I'm then running into the problem that it's no longer blank if it's got code in it. I turned off the limit on iterative calculations, but that didn't help me because instead of getting a circularity error, I just get a Y in every column, because isblank=false is always the case by virtue of me putting the code there.
Is the only way to fix this to create a new column so I can turn off multiple iterations? If that's the only way I can't really use that, since then I'd have to create a sister column for every column in the spreadsheet which is just too much.
=IF(isblank(H51)=false, "Y", "N")