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

I need a formula to calculate a profit margin of 25%. I need to know what my minimum sale price can be to always maintain at least a 25% minimum profit margin.
I have a fixed fee of $5 (column D). Another fixed fee of 15% of sale price (column C). Fixed cost of goods sold (column A).
While my variables will change, what forumla can I use to always get a result of 25% without having to play with changing the sale price constantly. I need to do this across thousands of products.

Solved by D. H. in 11 mins

Complete Microsoft Excel idiot here. Needing a formula for a spreadsheet that i am helping someone create. What he needs is a spreadsheet that changes numbers depending on other numbers for a particular product. He is wanting to track the minimum stock, stock on hand, and the stock needed to get minimum stock. He wants to be able to change one of those numbers and have the rest change on their own. Thanks!

Solved by A. L. in 16 mins

Need help creating a macro that shows the minimum numbers in a range and returns the data in a different cell

Solved by O. W. in 24 mins

I have to worksheets within a excel document - I have put in place a formula to clacluate the minumum amount out of 3 options. I would like to know how I get the option heading to select at the same time it selects the minimum amount?

Solved by X. W. in 28 mins

I need to calculate a formula that charges percentages to increasing values. if the value is under 20million, it's 4% charge. If it's 20-50 million, it's an additional 3% of that range added to the original. if it's between 50-100million it's an additional 2% of that rang added. if it's over 100million, it's an additional 1% added to the total. The minimum must be no less than 750,000. thank you

Solved by F. W. in 30 mins

In cell F33, I need to enter an IF function that evaluates the total number of computers donated from Safety Inc. If a minimum of 30 computers have been donated, the function needs to return "Goal Met" If fewer than 30 computers are donated, the function needs to return Under Goal.

Solved by X. Q. in 14 mins

Hello, I have a list of products in stock, with a simple formula for actual stock, minimum stock and number of the product to be ordered. I wish to generate a list in another sheet for products to be ordered form different suppliers.Please help

Solved by Z. W. in 25 mins

I need to find the average of the 3 smallest numbers from a column. Please see columns T, U, V, W
With the condition that they need to be higher then a certain number eg 60, 120, 180, 240
We had an operator just work on it and we thought they were correct but slightly out.
Example V2 should = 212.66 which is the average of the 3 minimum numbers from column N that are above 180.
If you sort column N you will notice the 3 lowest numbers will be 211, 213, 214. The average this = 216.66

Solved by V. L. in 21 mins

I have a spreadsheet that calculates lodging rates based on certain criteria. It currently uses Index and Match. Originally, the information was entered into the data sheet and the lodging formula would Index and Match criteria from that row with the Rates sheet and then return the amount due based on the number of Adults or Children entered into each night for the selected lodging. Now, the formula needs to be altered to accommodate a minimum of 2 adults in some but not all locations. I'm trying to avoid a lot of nested ifs - what's the best way to proceed?

Solved by K. L. in 28 mins

I need a formula to find exact match in a table and bring back the minimum date associated with the match. Note: there will be multiple exact matches

Solved by V. W. in 20 mins