IF statement: IF cell is blank, leave blank, if not display 1

1
votes

I would like column G to reference cells in column A. IF column A does not have a value in it, I would like the cells in column G to be blank. IF cells in column A have values in it, I would like cells in column G to display "1".

The cells in column A have a formula in it referencing a different sheet.

The formula I have so far is:

G1=IF(ISBLANK(A1), G1="", 1)

Right now, it displays "1" in column G because there is a formula in column A

A1=JE!C7

but I only need it to display "1" if there is actual data from the other sheet, "JE", in it.

If anyone know if a work around, I'd be very grateful. Thanks in advance!

2
excelexcel-formulaformula

2 Answers

0
votes

Use A1="". ISBLANK() will not return true if there is a formula in A1 even if that formula returns "".

Also G1="" is incorrect, you only need to put the "".

Use this formula:

=IF(A1="","", 1)

In A1 I put the following formula:

=IF(1=1,"",1)

And as you can see in G1 it returns "" and not 1.

enter image description here

0
votes

try this formula

=IF(OR(A12="",ISBLANK(A12)),"",1)

This should fix the issue