Copying an If Formula

[Guest]

I have written an IF formula in which if the condition is not satisfied it enters a cell reference in text format (e.g., =IF(a2>3,a2+b3,"b15")). The problem is that when I copy this formula the cell reference will obviously stay "b15" but in actuality I do want it to change as I copy the formula across (e.g., b16, b17, b18, etc.). Is there a way to rewrite the formula so that I don't have to make these changes manually? Thanks in advance for your assistance.

 

[Guest]

You could use the Column function in your formula. For example, if the formula is in column D:

=IF(B2>3,B2+C3,"b"&COLUMN()+11)

 

[nathan]

Click in the cell with the formula and then move the cursor to the bottom
right corner. The 'cross' changes to a square with little triangles on the
corner. Once it is like this you can click and drag to cover the cells you want
the formula in. This should duplicate the formula but with the correct
columns showing.

-----Original Message-----
I have written an IF formula in which if the condition is not satisfied it

enters a cell reference in text format (e.g., =IF(a2>3,a2+b3,"b15")). The
problem is that when I copy this formula the cell reference will obviously
stay "b15" but in actuality I do want it to change as I copy the formula across
(e.g., b16, b17, b18, etc.). Is there a way to rewrite the formula so that I
don't have to make these changes manually? Thanks in advance for your
assistance.

 

[Guest]

Hi
write it down this way:
=IF(a2>3,a2+b3,"b"&row(b15))