Sep 04 2021 11:37 PM
excel formula: Would appreciate it if you could assist me. I have a range of quantities with predetermine price. eg. qty 1-5 price is $50/pc, Qty 6-10 price is $45/pc and qty 11-15 price is $30. how to formulate so that when I put in qty as 3, the price will appear as $50?'
Sep 05 2021 01:50 AM
Sep 06 2021 10:37 PM
I can't speak to the appropriateness (or lack thereof) of this Excel question on this board but I can answer your question fairly easily: