Forum Discussion

jean-yvesl's avatar
jean-yvesl
Copper Contributor
Oct 17, 2023

Excel Formulas and Functions

Hello,
i would like to know what formula to use to make cell I4 blank if G4 is not blank when the formula is in L4
i populate each column individually.

is this even possible

thank you

excel
  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor
    Oct 18, 2023

    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.

    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic
    (LinkedIn)

Resources