as an alternative to zbor's formula

enter 200 in cell A1
enter this formula in A2

=A1-5

copy down

Nice Andy! I always forget that you can do nice little things like that !
I often feel we're too keen on providing a VBA or formula solution rather than using built-in Excel features.