Hi,
I've got some huge formulas to paste numerous times put I think all comes down to this:
I want to copy/paste cell A1 into cell A2 with this effect:

A1= B1 + AND(F1,F2)
A2= B2 + AND(F1,F2)
A3=..

Can I really do it or I need some kind of macro r something like that?
I have hundreds of them to copy!

Thanks