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?
