Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements
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), |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements
Think you could try something along these lines
Suppose you want to insert the value: XX into col A for any blank cells and retain any existing values for the non-blank cells You could put in B1: =IF(A1="","XX",A1) Copy B1 down as far as required. Then copy col B and overwrite col A with a paste special as values. Delete col B to clean up. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob" wrote: 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), |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if then statements | Excel Worksheet Functions | |||
If, then statements | Excel Discussion (Misc queries) | |||
If then statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
if statements | Excel Discussion (Misc queries) |