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

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