Get instant live expert help on I need help with profit function formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need help finishing a function to display when the profit is equal to $0.0
Solved by F. E. in 17 mins
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
23. Calculate the internal rate of return in C26 using the IRR function, using profit for the entire time period (including startup and project end).
Solved by A. H. in 20 mins
Calculate Net Present Value in D24:vR24 using the NPV function for each of those rates for Years 1-15 plus Project End, adding the initial Startup profit value in C21 to the result of the NPV in each cell.
Calculate the internal rate of return in C26 using the IRR function, using the profit for the entire time period (including startup and project end).
Solved by F. E. in 22 mins