Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |