Formulas
 

I need to create a formula that will find out the "exact" percentage of
an item that we sell.

If I have a quanity field in D13
Then a wholesale price in F13
In G13 I would put a percentage in..Example 5%
Then in I13 I have the formula =F13/(1-G13)

So if I put the following in:

749.53 in F13
5% in G13 which is the percentage of mark-up
788.98 appears in I13

But it should be 787.00 right ???
What am I doing wrong or need to do?


Thank You so very much

Kent Hansen

Try...

=F13*(1+G13)

Hope this helps!

In article ,
"Kent" wrote:

I need to create a formula that will find out the "exact" percentage of
an item that we sell.

If I have a quanity field in D13
Then a wholesale price in F13
In G13 I would put a percentage in..Example 5%
Then in I13 I have the formula =F13/(1-G13)

So if I put the following in:

749.53 in F13
5% in G13 which is the percentage of mark-up
788.98 appears in I13

But it should be 787.00 right ???
What am I doing wrong or need to do?


Thank You so very much

Kent Hansen

Yes it does!!!

I sincerly appreciate it very much : )

Have a great weekend

Thank You again
Kent


"Domenic" wrote:

Try...

=F13*(1+G13)

Hope this helps!

In article ,
"Kent" wrote:

I need to create a formula that will find out the "exact" percentage of
an item that we sell.

If I have a quanity field in D13
Then a wholesale price in F13
In G13 I would put a percentage in..Example 5%
Then in I13 I have the formula =F13/(1-G13)

So if I put the following in:

749.53 in F13
5% in G13 which is the percentage of mark-up
788.98 appears in I13

But it should be 787.00 right ???
What am I doing wrong or need to do?


Thank You so very much

Kent Hansen