Looking for an Excel Formula that will solve my issue of trying to calculate fees based on the value entered in a specific cell with the conditional fees being based on pallet quantities and order quantities.
I would like to create a formula in column B to calculate fees based on the qty entered in column C. There is a small order fee of $126.31 if the qty in column C is 4 or less (which I have 4 in column M - may be redundant). Next fee that could potentially be added to the small order fee is for our oversized pallet fee (column I) and crate fee (column K). This fee is charged per qty entered in column J. So if a qty of 3 is entered in C16, it would need to add the small order fee as well as the oversized pallet fee and the crate fee. If a qty of 12 is entered in C16, it would only calculate the oversized pallet fee and crate fee 1 time. If a qty of 24 is entered in C16, it would need to charge the oversized pallet fee and crate fee 2 times. As it's more than 18, but less than 36.
Additionally, the pallet quantity varies from model number to model number so it'd need to look at the value in column J and use that is the increments to determine how many times the fees should be charged.
Any and all help would be greatly appreciated! I have thousands of rows of data to apply this to and doing it manually would just take forever. Thanks again!
[link] [comments]
Want to read more?
Check out the full article on the original site