Automate a formula in excel
One way:
C2: =IF(COUNT(A2:B2)=2,A2+B2,"")
Copy down as far as required.
In article ,
Farris wrote:
Hello. I am trying to figure out how to have a formula automatically be
applied to the next row but only once information has been entered into the
cell which the formula applies.
Like if I wanted to add a1 + b1 and have the result in c1. How would I set
up the formula so that a result for c2 would only show and be applied if I
entered information in a2 and b2? Hopefully this makes sense.
Thanks for any help.
Farris
|