Formula should update when adding a row

[mjcsmile]

good evening,

i have probably a simple excel problem.

as you can see (attached excel) d7 is now b6/a6.
if i wanna add a new row and type in new data in b7 and a7, i want d8 to be updated so resulting to b7/a7

could someone help me with that issueexcel_1.xlsx

thanks a lot

[pjwhitfield]

Amend your formula to include error trapping to =IF(ISERROR(B6/A6),"",B6/A6) then drag it down a number of columns