Autofill formula to next cell without dragging

[Purdue02]

I want the formula in the above cell to autofill down without dragging when cells used in the formula are populated.


Ex/ Enter $ amount in B2 and C2 and the formula from D1 (=C1/B1) fills down automatically populating D2 with formula (=C2/B2).

I have a worksheet that someone else created that is currently doing this without a Macro, but can't figure it out.

Thanks.

[olasa]

As far as I know, Excel can not put a formula in a cell without code.

Ola


Note:
If it is to avoid #DIV/0!, this formula can be used:
=IF(AND(ISVALUE(B1),ISVALUE(C1)),C1/B1,"")