Making a Value in One Column Negative Based on Value in Another Co
 

Hello:

In an Excel 2003 spreadsheet, I have string fields in column C and in column
F. In column G, I have numeric fields.

Column C is the concatenation of columns A and B. Column F is the
concatenation of columns D and E.

I need a formula that will make values in column G negative where the values
in column C match the values in column F.

Let me see if can give an example.

In column C and row 2, you have the string value 10600357778035. This value
is ALSO in column F in row 181 and the corresponding numeric value in column
G in row 181 is "32". So, G181 needs to show -32.

Now, the values in column C in some cases may be in column F multiple times.
But, the point is that if column C is in column F, I want each corresponding
value in column G to be negative instead of positive. How do I do this? Is
there a formula that can do this without the use of VBA?

childofthe1980s

Making a Value in One Column Negative Based on Value in Another Co
 

I think that I just figured this out. I'm doing it a different way.

I put a column in between C and E to house the following formula:

=IF(ISERROR(MATCH(G2, $C$2:$C$258,0)),"new","match ")

This will place "match" for every match and "new" for everyone that does not
match.

Then, I will place columns D through I into a new spreadsheet and sort by
this column. I will delete the "new"s and make negative amounts for the
"match"s. That looks like that will work. If you have a different opinion,
please let me know.

"childofthe1980s" wrote:

Hello:

In an Excel 2003 spreadsheet, I have string fields in column C and in column
F. In column G, I have numeric fields.

Column C is the concatenation of columns A and B. Column F is the
concatenation of columns D and E.

I need a formula that will make values in column G negative where the values
in column C match the values in column F.

Let me see if can give an example.

In column C and row 2, you have the string value 10600357778035. This value
is ALSO in column F in row 181 and the corresponding numeric value in column
G in row 181 is "32". So, G181 needs to show -32.

Now, the values in column C in some cases may be in column F multiple times.
But, the point is that if column C is in column F, I want each corresponding
value in column G to be negative instead of positive. How do I do this? Is
there a formula that can do this without the use of VBA?

childofthe1980s