Heres what i would like to do. I would like column b to equal column a minus
x percent and appear in column c. 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.