In a sheet I have, in column A I have a formula referencing values in a separate sheet. In column G of the same sheet, I have a formula that references the cells in column A. I essentially want the formula in column G to see if the cell in column A has a value in it, if it does put a 1 in G column cell, if it doesn't have a value in the column A cell, leave it blank. The formula I tried for this is: =IF(ISBLANK(A1), 1, "") & IF(A1<>"",1,"")
That formula returns a "1" for all cells in the G column no matter if it has a value in the A column cell or not. In other words, I'd like the formula in column G to look at the cells in column A, if the cells in column A have fulfilled the formula that is in them, put a 1 in the G column cell, of not, keep it blank. But withe the column A cells already having a formula, this is showing that the column A cells have values inside of them, when they really don't.
Is there a work around for this?