View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.