Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003 | Excel Worksheet Functions | |||
Multiple Calculations in a Formula | Excel Discussion (Misc queries) | |||
Multiple Calculations in a Formula | Excel Discussion (Misc queries) | |||
Average of Multiple Calculations | Excel Worksheet Functions | |||
Multiple date calculations | New Users to Excel |