Heres what i would like to do. I would like column b to equal column a minus
x percent. The goal is to only have to eneter one formula and it will
automatically fill it in to the corresponding row.

EX.

A B
200 150
100 75
400 100

Is there a way to do this with out entering the fomula in to every row.