# Get instant live expert help on I need help with gross profit rate formula

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need a formula that will generate a percentage based off a chart of numbers. This is for a commission percentage reporting. So basically if the gross profit margin is 60%, the commission will be 15%. If the gross profit margin is 40%, the commission will be 5%. I have a cell that I will manually be entering the gross profit margin, so now I need a function that will generate the commission percentage based off what I type into the gross profit margin cell.
Solved by B. B. in 28 mins
Hi- I have a pivot table that is creating a profit and loss from several fields. I would like to create a % row- however as it is a row that is a function of several different fields I do not know how this is possible. Example would be gross profit % which is the gross profit \$ divided by the total income \$. Thanks, Dimity
Solved by O. H. in 12 mins
how to apply intense effect- Green Accent 6 shade style (the last style in the last row) to my gross profit to my data chart?
Solved by V. J. in 18 mins
I need a formula to calculate an employer 401k match, but the match caps at a flat rate. I have some people deferring a % and some deferring a flat rate. Whatever they are deferring needs to be capped and then calculated to represent the chunk for the 2 week paycheck. Ex: 3% deferral, gross \$2,000, caps at \$100/month. Ex 2: \$45/paycheck deferral, gross \$3,301.90, caps at \$90/month.
Solved by F. Q. in 19 mins
Using the information on the worksheet named ‘December’ design a spread sheet on a separate worksheet (named ‘Dec Valuations’) that: • Shows clearly inventory movements in units (opening, sales and purchases) and calculates the closing inventory (units). • Includes a closing inventory valuation in £ clearly showing how this is made up • Incudes a separate calculation of the gross profit, showing revenue, cost of sales (split into its components) and the gross profit figure
Solved by O. B. in 27 mins