if then, change value of a cell range
is this possible? or some other syntax to make this work
=IF(A6="WE",A11:A24=" ","")
if A6 = “WE” then a ceartain column range is cleared of its contents, if not content stays as is
help is greatly approciated.
thanks.
|