profit

  1. L

    How to get a profit percentage of two columns in a pivot table ?

    I have a pivot table that is pulling data from another table. From the table that Iam pulling the data from there are a few columns. How do I get the percentage profit in a new worksheet pivot table Column if the table that Iam pulling the data from doesn't have a column that shows the...
  2. L

    How do I get a percentage of two columns in a pivot table ?

    I have a pivot table that is pulling data from another table. From the table that Iam pulling the data from there are a few columns. How do I get the percentage profit in the new pivot table Column if the table that Iam pulling the data from doesn't have a column that shows the percentage...
  3. L

    How do I get profit percentage in pivot table ?

    How do I get profit percentage in pivot table ? There is contract sum and cost.
  4. P

    Chart/Graphing problems

    i am working with two sets of information. each set has 13 values for 1 person. and this is for 13 week period. Person 1 Person 1 Dollars Volume 10 1 20 2 30 3 40 4 50 5 60 6 70 7 80 8 90 9 100 10 110 11 120 12 130 13 I am trying to get this into a graph that shows something like this...
  5. G

    what price will achieve target percentage

    wonder if anybody here would be kind enough to help me with this headscratcher. i am working on a gross profit calculator for a restaurant. i want to include 3 methods of viewing the affect on gp. increase to (new price) method, and increase by (fixed amount) method are straightforward...
  6. P

    Trying to make a formula to calculate the Profit and Lose in Forex trades.

    Hello Dears, As in image above : i am trying to make a formula for column J and K: - As in column "J" i need the Pips In Lose to be calculated in case i type "L" in column "I" - As in column "K" i need the Pips in Profit to be calculated in case i type "P" in column "I" - In column "I" when i...
  7. G

    Excel formula at the moment

    For my excel formula for (capital) profits I need the values in some of the cells. However I only want the values of these cells at the moment when some capital is sold. When later buying back, these values will influence the profit, so is it possible in excel to only use the values in the cells...
  8. H

    Logical Formula with Text

    I have the the following formula below =IF(B25-C25>0,"The the profit has increased by "&TEXT(B25-C25,"R#0,##0")&""),IF(B25-C25<0,"Thn the profit has decreased by "&TEXT(B25-C25,"R#0,##0")&"") I get #value ! If the result of B25-c25 > 0 , then it must show Then the profit has increased...
  9. N

    Formula that maintains a persistent profit margin

    Hi guys, World cup is around the corner and i'd like to do up a spreadsheet that highlights a persistent profit margin. I've done up a basic version of this. But i'd like there to be a column that highlights how much extra we will need to put in if we wanted the payout for each outcome to be...
  10. P

    Enter "Note" below specific text

    Hi all, I would like to create a VBA code in excel 2016, so that to run through col. "AK" and where find the text "NET PROFIT / LOSS" should enter below after a blank row the below note: "Note: The above Net Profit & Loss arises, thereafter we entered the accounts dividends received, banks...
  11. D

    Commission split between partners and agent

    Hi All- I have been working....struggling on an excel sheet to determine the commission split among 2 partners on a per deal basis which would include the reimbursement from Partner A to Partner B for the acquisition of the company. (Here is the link to my XLS sheet. ) Here are a few things to...
  12. A

    Profit % margin calcaulator

    Hi, I am attempting to construct a profit margin calculator and am having some difficulty achieving the desired result. I have a basic profit calculator; profit(a4) = saleprice(a1) - cost(a2) - minus overhead(a3) and profit margin =(saleprice(a1)/profit(a4))*100 What I am trying to do is...
  13. C

    Best way to combine multiple sheets with multiple subtotals with multiple criteria

    I'm using Excel 2016 I have 2 different worksheets in 1 workbook. First worksheet (Sales) is sales from a POS system - which is already subtotaled By Item / By Profit Center. Second worksheet (INV Tx) is Inventory from an accounting system - which was NOT subtotaled detailing how many of...
  14. B

    Formula to apply multiple rates (that compound) to a core number.

    I seem to recall an excel formula that would allow me to take a direct labor cost, apply a fringe rate, apply an overhead rate, apply a general & administrative rate, and finally apply a profit rate, in one fell swoop. I thought it was the [ =schedule ] function, but that doesn't seem to exist...
  15. J

    using a single formula from an external workbook to run formulas on a list of values from another workbook

    Hello, I cannot seem to work out the solution to the below. I am trying to use a list of values from workbook 1 to calculate the result of a single complex formula in a workbook 2. Essentially Workbook 2 is a profit calculating workbook, with many many variables that change on a daily basis...
  16. K

    If Statement VBA Search and Output Help

    Hello All, I have currently have trouble developing a VBA/macro that would do a search in a data range within a table and once search it will populate another range with the information I need. Below I have an example of what I am trying to do but can't seem to wrap my head around <tbody> A B...
  17. G

    Understanding context transition - duplicate rows

    So I thought I was starting to understand context transition, but I got thrown a curveball over the weekend. I have a dataset that records sales, where each row is a single sale transaction. Columns include a customerid and product id that both connect out to dimension tables, but also includes...
  18. M

    Help to automate a repricing tool using if statements

    <tbody> sku stk stk weeks left total week sales uk sales germany sales spain sales uk profit german profit spain profit Total uk prof total german prof total spain prof pen 10000 10 1000 500 500 0 £1 £3 £5 £500 £1500 £0 </tbody> Hey Experts! I'm trying to create a repricing...
  19. A

    How to attach an event to a html table cell?

    The html table (sample) is shown below. I want to attach an event (which opens a hyper link), when the mouse cursor is on Guj. Automotive. The event has to be fired, when the user performs a "LEFT click on the mouse". Please note that, the table doesnt have any events attached to it via...
  20. L

    Sum of profit

    Hi Im trying to set up a spreadsheet where in one column I have each day of the month, against each day I'm putting in my final figure on a betting site, e.g... <tbody> Start with £20 Mon £25.60 Tue £10.00 Weds £15.00 Thurs Profit/loss -£5 </tbody> So on Monday for eg. I made a...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top