I am trying to insert a result of an if statement into a column that has some
blank spaces but also has some correct values the same column. I want to
build a Macro that would include this statement. How do keep from overwriting
the cells that have the appropriate values when I drag the formula down the
column? =IF(E:E="Default",80, ). It creates a circular reference if I
include the column (F:F),