Excel Formulas and Functions

Hi jean-yvesl,

The following formula will make cell I4 blank if G4 is not blank when the formula is in L4:

=IF(NOT(ISBLANK(G4)), "", I4)

This formula uses the IF function to check if cell G4 is not blank. If it is, the formula returns an empty string (""). Otherwise, the formula returns the value of cell I4.

To use this formula, simply enter it into cell L4. Then, when you populate cell G4 with a value, cell I4 will automatically become blank.

Here is an example of how to use the formula:

Column G | Column I | Column L
----------|----------|----------
           |           | =IF(NOT(ISBLANK(G4)), "", I4)
10        |           |

If you enter the value 10 into cell G4, cell I4 will become blank. If you clear the value in cell G4, cell I4 will remain blank.