0

I have an "if" formula that I need to duplicate for many columns, preferably without typing each if statement. Formula is =if(k5>j5,0,j5-k5) I have columns j through cy to include in the formula string.

Improve this question
2
  • Welcome to Super User. Can you please share with us what you've tried so far to resolve this on your own? Have you done an Internet search for copy excel formula across columns?
    – CharlieRB
    Jun 27, 2014 at 18:43
  • 1
    You could also use "=min(0,j5-k5).
    – LDC3
    Jun 27, 2014 at 18:44

1 Answer 1

Reset to default
1

If you're formula is referring to adjacent cells and and they are consistent then you should just be able to copy and paste the formula and it will adjust the formula itself as you move across the columns. ie. your first equation would be in cell J1 referring to cells J & K. Copy that equation and paste into cell K1 and the equation will adjust to refer to cells K & L and so on and so forth.

Improve this answer

Not the answer you're looking for? Browse other questions tagged .