Forum Discussion

tmartinez380's avatar
tmartinez380
Copper Contributor
May 02, 2024

Question

Hello
How do you empty cells based on a particular value entered in another cell?
Example if cell A1 = NA
Cells A2:D6 are emptied?

Thanks

Thierry

  • MAngosto's avatar
    MAngosto
    Iron Contributor

    tmartinez380 

     

    That cannot be done unless writing some VBA code.

     

    Another possibility:

     

    Write on each cell of range A2:D6: =IF($A$1="NA","","Something else here")

Resources