View Single Post
  #1   Report Post  
jo8502 jo8502 is offline
Junior Member
 
Posts: 1
Default 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.