Hello,

I am trying to show bond yield charts, everytime the interest rate changes.

I have a series of data. And in cell A1 I have the interest rate. I want
each of the cells in the series of data, to equal the sum of A1 + 0.5, if
cell A1 is greater then 5.00. Otherwise I want each cell in the series of
data to equal the sum of A1 - 0.5, if cell A1 is <5.00. Also I want the A1 +
0.5 bit to occur for only half of cells in the data series, and the other
half with the A1 - 0.5 bit.

Any ideas how I can proceed.

Regards