Best way to accomplish task

Occasional Visitor

Let's say I have a column(A) of numbers that can be anything from 0 to 15000.  In the next column I would like the cell to be blank if number is 1800 or less.  With any number greater than 1800 I would like the cell result to be as follows:

  A            B

1801     499

1802     498

1803     497

etc. up to 15,000


What is the most efficient way to do this?



1 Reply


In B2:


Fill down.