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...