B
banderson
I was wondering if anyone could help me. I have seen a few examples
that are fairly close to what I'm looking for.
I'm wanting to look at a range of data in a column and find all the
cells that have a value not equal to 0, then move it one column to the
left and change the sign to negative.
Below is the columns I have setup:
Column A B C D
E
Cash 15,343.00 0 147.34 0
Petty Cash 0 150.00 300.00 0
name 0 20,000.00 20,000.00 0
wachovia 0 1,569.95 0
1,569.95
I'll explain the columns to you Column B = Debits, Column C = Credits
So column C is the column being checked here.
If it does not have a 0 in it move the value to the corresponding cell
in Column B and make it negative.
Thanks
that are fairly close to what I'm looking for.
I'm wanting to look at a range of data in a column and find all the
cells that have a value not equal to 0, then move it one column to the
left and change the sign to negative.
Below is the columns I have setup:
Column A B C D
E
Cash 15,343.00 0 147.34 0
Petty Cash 0 150.00 300.00 0
name 0 20,000.00 20,000.00 0
wachovia 0 1,569.95 0
1,569.95
I'll explain the columns to you Column B = Debits, Column C = Credits
So column C is the column being checked here.
If it does not have a 0 in it move the value to the corresponding cell
in Column B and make it negative.
Thanks