Changing True/False Data depending on another cells value

Hi,



I was curious, I have an accesss database/excel database that we manage all of our products in. I have recently been sent a sheet that has a lot of discontinued products. I have matched those skus up to the products and was wondering if there was a way to change the value in a column based on if the cell next to it has any kind of data in it.





for example



Product Name........DISCONTINUED............DIS SKU

Fabric 1......................False...................5468

Fabirc 2......................False...................

Fabric 3......................False...................9821





So I want the "False" to change to "True" in clumn "B" because there is data in COLUMN "C". I only want the Fabric 1 and 3 columns to saw true.



Is this possible?

Hello mtrant,

You could add a worksheet formula to column "B" and drag it down.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks a lot, I was missing the " " and for some reason that completly stopped the formula from working.