Get instant live expert help on I need help with formula for profits

“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

Hi I have an excel spreadsheet which I am looking to get modified. . At the minute there is 1no pivot table page and one report page. I am looking to add on extra sheets. With the same formula and on the pitot table I’m looking to add on extra columns which are the sum of profits and above it will be sheet 1 sheet 2 sheets 3. The box on the right will stay the same as it will add up all the results of all the sheets month by month. So basically the pivot table stays much the same except there will be and extra columns for sum of profits for each sheet. I may have up to a total of 30 sheets open so will need 30no columns with sum of profits.
Solved by C. F. in 27 mins
spreadsheet which I am looking to get modified. I use it for Fx trading and looking at returns of each currency pair.. I am looking to add on extra sheets With the same formula and on the pitot table I’m looking to add on extra columns which are the sum of profits and above it will be sheet 1, 2 and 3. So basically the pivot table stays much the same except there will be and extra columns for sum of profits for each sheet. I may have up to a total of 30 sheets open so will need 30no columns with sum of profits. Also when I adjust the numbers in the report it doesn’t adjust the figures in the pivot table.
Solved by V. W. in 24 mins
I need to work out the profits from each customer and from each product
Solved by O. Y. in 20 mins
DON'T PICK IF YOU CAN'T ANSWER CORRECTLY!!!! I want a model that provides data for several products using common parts, each with a different profit margin per unit. Parts are limited, so the problem is to determine the number of each product to build from the inventory on hand in order to maximize profits. Should with SOLVER....Urgent please
Solved by T. D. in 24 mins
I need to calculate interest on a loan and show how the interest amount changes as principle is paid on the load with no maturity date. The principle payments are calculated 4 different ways to show varying % of profits.
Solved by G. B. in 14 mins