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.
|