Prev: Basing math on duplicate entries in a formula
Next: if formula results in False - can you help?
From: Pulling Hair on 5 Mar 2010 16:10
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.
From: Pete_UK on 5 Mar 2010 17:41
Try this:

=(G13*(1+G6)*(1+G8))/C13

Hope this helps.

Pete

On Mar 5, 9:10 pm, Pulling Hair
<PullingH...(a)discussions.microsoft.com> 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.

 | 
Pages: 1
Prev: Basing math on duplicate entries in a formula
Next: if formula results in False - can you help?