| 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 | |||
Hybrid Mode
