Help with Numbers on Replacing Values

Discussion in 'Business Applications' started by Eraserboy9915, Jul 11, 2012.

Not open for further replies.

Joined:
Jul 11, 2012
Messages:
2
I have three columns in Numbers (Column H, J, and R). Columns R is an exact copy of Column H.
Every time a certain value appears in Column H, I need the corresponding value in Column R (but not Column H) in the same row to become negative.
Now, I have over 100k rows that I am working with, so manually changing seems to be out of the question.
How exactly can I do this?

2. WendyMRetired Trusted Advisor

Joined:
Jun 27, 2003
Messages:
4,042
Hi Eraserboy, welcome to TSG.

You don't say what program you're using, but I assume Excel? If so, you can use an if formula. You don't say what value you need to find in column H, but I'll use 5 as the example. You'd put this formula in R1 and drag it down the rest of the column.

=IF(H1=5,-5,H1)

The formula says "if the value in H1 is 5, then make R1 = -5. If not, make it the same as H1". Replace the 5 and -5 with whatever value you need.

Hope that helps.

Joined:
Jul 11, 2012
Messages:
2
Thanks for the Response Wendy.
I'm using the program Numbers on a Mac. I see what you're saying, but I don't want to change the value of the number in column R to the number in column H. I just want to make the value already in R negative if column H has a value of "SD" present. Would the same concept apply in this case? If so, could you please explain a bit more.

4. WendyMRetired Trusted Advisor

Joined:
Jun 27, 2003
Messages:
4,042
Oh, sorry, I didn't realize Numbers was a program.

When you said that Column R was an exact copy of Column H, I assumed they had the same values. If the values are different, it's probably easiest to use a helper column. You can insert a column next to R and use:

=IF(H1="SD",-R1,R1)

Then you can hide Column R so that you only see the numbers in Column S. Does that make sense?

As Seen On

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!