Cell Reference & formula

  • Thread starter Thread starter PL
  • Start date Start date
P

PL

Hi

Using Excel 2007.

In row 1, i have a row of different numbers: 1, 4, 5, 6, ...

In row 2, I want all of it to be the negative of row 1. -1, -4, -5,..


So I used cell reference for the 1st cell and copy & paste the formula for
the whole row. But here a strange thing happened, all the cell in row 2 show
the value of my 1st cell, although in the function bar they show correctly
the formula and cell reference of their respective cells.

I used this method many times and this is the 1st time this happened. How do
I correct this problem?

Thanks
 
Make sure calculation is set to automatic...

In Excel 2007:

Formulas tab>Calculation>Calculation Options>Automatic
 
Paste the below formula in any of the cell in A Column.

=VALUE("-"&A1)

OR

=A1-(A1+A1)

Now copy the cell in which you have pasted the above formula and paste it
for the remaining cells to the rightside.

Remember to Click Yes, if this post helps!
 
Try this...

Assuming all the numbers in row 1 are positive numbers.

=-A1

Then copy across.
 
Thank you Biff Sir! I learned one valuable information today!!!

Remember to Click Yes, if this post helps!
 
Good deal!

--
Biff
Microsoft Excel MVP


Ms-Exl-Learner said:
Thank you Biff Sir! I learned one valuable information today!!!

Remember to Click Yes, if this post helps!
Click to expand...
 
Back
Top