Proble with copying cell vs contents

[samyer]

Excel 2003; I have a range of values in column B. For each cell in column B I calculate a number in column C using the following formula:

=IF((B2:B721)<=48.5,2*(0.4143*(B2:B721)-10.566),2*(0.03347*(B2:B721)+7.907))

The first calculation cell (C2) works. If I try to copy it to remainder of the range I get the exact same value so I tried using $B$2:$B$721, etc. That works for one cell copy but if I try to copy and drag across the range it doesn't work. In other words if I copy the contents (up at the formula line) of cell B2 and the copying it to B3 that works. But if I try copying the cell it doesn't.

Any ideas what I'm doing wrong?

Thanks in advance

 

[JonXL]

Excel 2003; I have a range of values in column B. For each cell in column B I calculate a number in column C using the following formula:

=IF((B2:B721)<=48.5,2*(0.4143*(B2:B721)-10.566),2*(0.03347*(B2:B721)+7.907))

The first calculation cell (C2) works. If I try to copy it to remainder of the range I get the exact same value so I tried using $B$2:$B$721, etc. That works for one cell copy but if I try to copy and drag across the range it doesn't work. In other words if I copy the contents (up at the formula line) of cell B2 and the copying it to B3 that works. But if I try copying the cell it doesn't.

Any ideas what I'm doing wrong?

Thanks in advance

Are your calculations set to Automatic?

This sounds like exactly the behavior you get when calculations are set to Manual.

 

[cerfani]

that formula is setup to be an array formula and you need to press Ctrl+Shift+Enter to input it... Locking the range with $ signs is done when you dont want the dragged formula to get updated based on relative position to the starting point

 

[samyer]

Thanks!! I give it a try!