![]() |
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. |
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