ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiple calculations in 1 cell (https://www.excelbanter.com/excel-worksheet-functions/258153-multiple-calculations-1-cell.html)

Pulling Hair

multiple calculations in 1 cell
 
In cell C 13 is the quantity of units. In cell G 13 is the total cost. In
cell G 6 is the percent of overhead and in cell G 8 is the percent of profit.

I want to enter a formula in cell H 13 that will give me a unit price which
is (cost plus overhead) + profit.

Pete_UK

multiple calculations in 1 cell
 
Try this:

=(G13*(1+G6)*(1+G8))/C13

Hope this helps.

Pete

On Mar 5, 9:10*pm, Pulling Hair
wrote:
In cell C 13 is the quantity of units. *In cell G 13 is the total cost. *In
cell G 6 is the percent of overhead and in cell G 8 is the percent of profit.

I want to enter a formula in cell H 13 that will give me a unit price which
is (cost plus overhead) + profit.




All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com