Posted by Lars on November 02, 2001 2:39 PM
each month I will add a number - I want to create a formula that will add the numbers in column b and multiply it by 1.5 until it reaches 1,000,000. Then when this number exceeds 1,000,000 multiply the excess over 1,000,000 by 1.65 and add that to what the product was from 1 - 1,000,000. Then when the total becomes greater than 1,400,000 multiply that excess over 1.4M by 1.8 and add that.
summarize 1-1M * 1.5
1.1M - 1.4M * 1.65
1.41M - and greater * 1.8
I need a miracle!