Leave Existing Data while formatting

[BrWolv]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am trying to format multiple columns, which have some data already populated in various cells. I would like to use an =IF statement to return “NA” on cells that contain certain text & then use the painter to copy the formula (I have 842 rows & need a statement similar to this in about 25 different columns)<o></o>
I am having trouble getting the existing data to remain the same after I paint the =IF statement. Is there a simple way to complete this formula, which would allow me to paint over all cells and only change the cells in which the value is true? An example of what I am trying (red text is for reference only, it is NOT what I am trying to type in the statement);<o></o>
=IF(A2="DSI", "NA", leave existing data in cell as is)<o></o>
Can anyone help me out?<o></o>
<o> </o>
Thank you!!<o></o>

 

[Oaktree]

Maybe just =IF(A2="DSI", "NA", A2) ?

 

[BrWolv]

Actually tried that one, & that replaces the existing data (returns NA in all cells with any data). Any other suggestions? I appreciate your time either way.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Thanks <o></o>

 

[BrWolv]

Can anyone help with this, I need to clean up an existing workbook which is already populated with various data. I need to insert multiple formulas & conditional formatting rules in a column based upon values in other columns. I can figure out all of those items, however, I cant seem to figure out how to leave the existing data alone. The formatting I am adding will add text to cells, such as Pending, or NA & the cells that contain data are either a date or a name (so there isn’t any existing formula, just data input).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
This is a huge workbook, so doing it row by row isn’t an option, one example of a formula I am trying to figure out is;<o></o>
=IF(A2=”DSI”, “NA”, “if that argument is false, I need the existing data to remain in cell B2”)<o></o>
Anyone have a solution?<o></o>
<o> </o>
Thanks in advance!!<o></o>

 

[Oaktree]

I'm not sure I understand what you mean by "leave the existing data alone".

As I interpreted your situation, you have a block of formulas in, say, E2:H100.

Then, in a second block of formulas in, say, J2:M100, you wanted e.g. J2 to ="NA" if A2 = "DSI" and otherwise return E2's value.

Is that not what you want? Maybe you are looking for a macro to replace E2:H100's *formulas* to include the IF statement?