Best way to accomplish task

Question

Let's say I have a column(A) of numbers that can be anything from 0 to 15000.&nbsp; In the next column I would like the cell to be blank if number is 1800 or less.&nbsp; With any number greater than 1800 I would like the cell result to be as follows:&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1801&nbsp;&nbsp;&nbsp;&nbsp; 4991802&nbsp;&nbsp;&nbsp;&nbsp; 4981803&nbsp;&nbsp;&nbsp;&nbsp; 497etc. up to 15,000&nbsp;What is the most efficient way to do this?&nbsp;&nbsp;

hansvogelaar · Answer

baddiver&nbsp;
In B2:
=IF(A2&lt;=1800,"",2300-A2)
Fill down.

Forum Discussion

Best way to accomplish task

Share

Resources