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

@baddiver 

In B2:

=IF(A2<=1800,"",2300-A2)

Fill down.