IF A1="" THEN "make A2 empty

[DanAyo]

I've new to Excel. I'm trying to see if a certain cell is empty and if it is then make a another cell empty also. (IF A1="" THEN "make A2 empty)

I've tried this, but it doesn't work.
=IF(A1="",A2="",)

This does work
=IF(A1="",TRUE,FALSE)
Depending on whether A1 is empty or not, I get either TRUE or FALSE

I've spent a lot of time searching the Internet, but haven't found an answer. Maybe I'm not asking the proper question.

What am I missing?

[6StringJazzer]

An Excel function is used in a cell to give a value to that same cell. You cannot use a function in one cell that puts a value into a different cell.

The way to do this is to put the following formula in A2:

=IF(A1="","","?")

The question mark is what goes into A2 if A1 is not blank--I don't know what you want to do in that case.

[mehmetcik]

It depends on what is in A2.

If you have a formula in A2 then wrap

Please Login or Register  to view this content.

around your formula.

If you are uncertain what is in A2 then you need a macro.

Right Click on your sheet name at the bottom of excel and select view code.

Paste this code into the module that opens and close it. Save your workbook as macro enabled.

Please Login or Register  to view this content.

[DanAyo]

The cell I want to make empty (A2) is a cell that the user enters numbers into. It has no formula. Because this is the case, I don't think I can write a formula in A2.

I would prefer not to use any macros on the sheet. Do I have anyother options?

I appreciate your help.

[mehmetcik]

No other option. Sorry.

[DanAyo]

I may have a different solution that would require user intervention.

Here is my actual formula. I entered this in a cell next to the one I want to clear IF another cell is empty.
=IF(AND(F9="",G10<>""),"Remove date from G10",)

The I Conditionally Formatted the Cell to turn RED if the conditions was met in order to highlight the message.
=AND($F$9="",$G$10<>"")

Do you foresee any issues with this?

[6StringJazzer]

It can work but any time you require user cooperation it is out of your control.