I would like to create a if than else function in excel. I I have a large file of 7000 records I would like to set.
if column a1 = "not mapped",
set column b1 = blank
set column c1 = blank
leave values to current status.
attaching a spreadsheet.