Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA HELP:
I will give you an example to best ask my question
I have a product that has a cost of 829.78 and i need to mark that up a certain percentage. The way i do it on the calculator is i would do 829.78 Divided by .93 for 7 percent. For example in this calculation it would give me 892.24. I would like a formula to automatically calculate at that rate in the sheet. If you could help me out that would be greatly appreciated. The unit prices are in Collumn E. Thanks for you help in this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA HELP:
I'm not clear on what you're asking, but if you're asking how to increase
829.78 by 7%, then =829.78*1.07 will give you the answer. Dave -- Brevity is the soul of wit. "Eric Svatik" wrote: I will give you an example to best ask my question I have a product that has a cost of 829.78 and i need to mark that up a certain percentage. The way i do it on the calculator is i would do 829.78 Divided by .93 for 7 percent. For example in this calculation it would give me 892.24. I would like a formula to automatically calculate at that rate in the sheet. If you could help me out that would be greatly appreciated. The unit prices are in Collumn E. Thanks for you help in this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA HELP:
Easy enough.
in cell F2 =E2*1.07 and copy that down the column. "Eric Svatik" wrote: I will give you an example to best ask my question I have a product that has a cost of 829.78 and i need to mark that up a certain percentage. The way i do it on the calculator is i would do 829.78 Divided by .93 for 7 percent. For example in this calculation it would give me 892.24. I would like a formula to automatically calculate at that rate in the sheet. If you could help me out that would be greatly appreciated. The unit prices are in Collumn E. Thanks for you help in this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA HELP:
Not sure I get you need but try this:
=E1/0.93 if you need the rate from another cell that is a little different and you'll have to tell how it is in the cell e.g 7 or .07 or 7% -- -- -John Please rate when your question is answered to help us and others know what is helpful. "Eric Svatik" wrote in message ... I will give you an example to best ask my question I have a product that has a cost of 829.78 and i need to mark that up a certain percentage. The way i do it on the calculator is i would do 829.78 Divided by .93 for 7 percent. For example in this calculation it would give me 892.24. I would like a formula to automatically calculate at that rate in the sheet. If you could help me out that would be greatly appreciated. The unit prices are in Collumn E. Thanks for you help in this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |