Math problem for you all that I'm trying to solve without a bunch of IF statements or lookups.
I have an input cell for widgets. I price 400 widgets at $32.00 each. For every additional widget the price will be one penny less. So, 401 widgets entered in will yield a price of $31.99, 402 widgets equal $31.98, etc, etc....
At 500 widgets, the price decrease changes to two pennies less for every incremental widget. At 600 widgets the price then is fixed at $29.00 At 400 or less the price is $32.00/each.
Is there a formula/function able to solve this?
Thanks!
I have an input cell for widgets. I price 400 widgets at $32.00 each. For every additional widget the price will be one penny less. So, 401 widgets entered in will yield a price of $31.99, 402 widgets equal $31.98, etc, etc....
At 500 widgets, the price decrease changes to two pennies less for every incremental widget. At 600 widgets the price then is fixed at $29.00 At 400 or less the price is $32.00/each.
Is there a formula/function able to solve this?
Thanks!