View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default Automate a formula in excel

I don't know if this will help:

=IF(OR(A2="",B2=""),"",A2+B2+IF(OFFSET(C2,-1,0)="",0,OFFSET(C2,-1,0)))

cannot start in row 1 with this as it would be in error.

"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