I have a small list of numbers that I need to reduce to a figure, but keep positive. The "reduction" figure needs to be rounded to the nearest million.
Eg:
39,790,834.
I need a cell function that will produce a positive number, in round millions, that will reduce the number above, to a figure between 1 million and 2 million. The answer in this example would be -38,000,000, and the formula will need to reference to a single source cell. That is - 39,790,834 will reside in c4, for example.
Im stuck !