“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello.
I have a problem. I think Ill explain what I am doing first. I am trying to create a calculator for shipping purposes. Shipping is a minimum of $70.00 USD and $1.75 per pound over $70.00. Now the shipping is done by volumetric weight , for example L x W x H * 1.66 - 2 x 2 x 2 * 1.66 = 13.28 . Therfore 13.28 x $1.75 = $23.24 . But its a minimum of $70.00 so I cannot calculate off the formula until its over $70.00. How can I accomplish this?

Solved by I. H. in 29 mins

Same as posted earlier but wrong answer: After a complicated vlookup using an array I am looking to merge the results into a single cell and remove duplicate values leaving a comma delimited cell. Note that this is an example and the real case will have hundreds of results to combine (from D2 to noidea2 (minimum 100 cells on the column) and from D3 to noidea150 (minimum 150 on the row)) and filter out repetition of results to a SINGLE CELL with commas between results.

Solved by V. S. in 25 mins

Create a price table of minimum sale prices for an item based on hitting a predetermined profit margin for each price increment

Solved by D. D. in 17 mins

calculate (using profit calculator) minimum sale price needed to achieve set profit margin for various cost price increments

Solved by S. H. in 23 mins

I have two tables (say of size 100x2 and 150x2)with Description in one column and Quantities in the other column, in both the tables. I want to compare both the tables and extract the minimum quantity against a particular description row.

Solved by E. H. in 22 mins

i have 8 items with different QTY's associated to each.
The lowest QTY of 1 is 10,000
So, I am trying to see how many 4 packs I can make based on the minimum QTY of 10,000
Can someone help?

Solved by A. J. in 19 mins

Employee is paid a bonus depending on whether objective is met and at which tier. In order to be eligible for the bonus, employee's objective must be 100% at the minimum. If the objective is between 100-109.99% and employee achieved a survey score below 935, then employee will only be awarded $500. If objective is met and employee achieved a survey score at or over 935, employee will be awarded $1000. If objective is at 110%+ and employee achieved a survey score below 935, then employee is rewarded $1000. If objective is at 110%+ and survey score is at or above 935, employee is awarded $2000.

Solved by X. W. in 30 mins

I want to calculate the number of units that are required to be purchased with a minimum $100 purchase. But the minimum purchase needs to be rounded to be multiples of the number of units that are sold in a package.
For example
The Unit price is $60 per 1,000 pieces or $0.06 each.
The package size is 2500 pieces.
So I need to calculate how many packages I have to buy in order to exceed $100 and that enables me to ship full packages. In this case, I know the answer is one package - which would be $150 (clearly over the $100 minimum). How would I write an Excel formula in order to calculate 80,000 different types of units?

Solved by M. Y. in 26 mins

Hello
How do i change this formulae:
=IFERROR(SUM(C16:C29,B15),0)
It adds up calculated fields and product options.
I want it to show a minimum price of £100. Only once options have started to be chosen. I don't want it to start on £100 when the sales team are on the phone. As they will say a minimum of £100 which will put customers off before they start.

Solved by B. B. in 27 mins

use solver to determine the minimum number of coins needed to make change for 92 cents.

Solved by E. H. in 13 mins