net

Good afternoon. I am seeking help with a tiered commission schedule that appears to deviate from everyone else. I have included a document here: https://drive.google.com/file/d/103b0w6uWLwOjTNbm9GGl_EkJMQ2ozcFt/view?usp=sharing The gross commission goes into C2. The Gross Totals has a...

Hey Team! Im stuck on a excel problem. Wonder if someone could give me some advice? Its a simple scenario, but Im having trouble with the function. Lets say you are going to get paid out based on the performance if your company. So any net income over $425,000 but under $725,000 you get 100%...

I am using Excel 2016. I added a column to the data set that my Pivot Table is pulling from and one of the calculations is giving me a #NAME ? error now. How can I fix this? The columns I am using are below. The error is in the third column (Invoice+Orders % Budget). The column I added is...

Hi All, Need to execute net user command using CMD through macro. the account name is being captured in excel and then using macro need to execute below command: net user "username from excel" /do here is my code below and appreciate your help: Sub Button3_Click() Dim wb1 As Workbook, wb2 As...

I am trying to write a formula that will calculate Accounts Receivable due dates. Some of the due dates are easy, because a few of our customers have terms of Net 30, Net 45, etc. However, a handful of our customers have due dates that read: "2nd day / 2nd month". In other words, if the...

I learned a bit of VBA modifying recorded macroes but I now want to become a real VBA expert (with Excel 2010). What are the best compact / regular / complete guides for learning VBA on the net? I mean something like these: http://www.excel-spreadsheet.com/vba/vba.htm...

:confused: I'm new to excel coding. Have combined some codes for my Quotation file to work. Now, my boss thought of adding an option for when I click the BRACKET COST button, the item cost would change into the amount that i will link from a worksheet within this workbook. here's a part of what...

Hi All, I have this formula that gives me half of the value I need: =SUMPRODUCT(--(TEXT(CSVData!F2:F65535,"mmyyyy")=TEXT(E2,"mmyyyy"))*(CSVData!K2:K65535="No")) What I need to do now is add a lookup for town as well as the "No" value. so something like...

Hello, I am using Win 10, and an alternative to microsoft excel called PlanMaker since I dont have a copy of microsoft excel. I have had trouble trying to post an example of the data so I will try to explain with a picture and a brief description. I need help with simple formulas, working...

I am new to this DAX language and I am sure the solution isa very simple one, but I would appreciate some help.<o:p></o:p> <o:p> </o:p> I have created two measures. <o:p></o:p> MAX MONTH=MONTH(MAX('MONTHLYSALES 002'[Date])) 2016 ADJ NET SALES-YTD= CALCULATE(SUM([ADJUSTED NET SALES])...

Hi All, I have a spreadsheet with details of shares bought and sold, I have an add-in that calculates the current prices and everything is working fine but I would like to add a NET COST cell that calculates the cost of shares currently in my possession. The below example data is...

I am trying to put together a template showing the net present value of three years' of weekly payments. Each payment is $5,000. I am trying to compare that to lump sum payment at the end of each quarter for the three years and also to a lump sum payment at the end of each of the three years...

So in column A1 I have an average monthly net worth increase of the past 12 months listed as a percent -- 1% In column B1, I'd like to insert a formula that calculates the annual net worth increase rate as a percent based on A1, assuming a net worth constantly grows at 1% each month for 12...

Hi All, I am trying to figure out a formula so I can create a calculator for use in my business. I am trying to figure out the calculations needed to net down the commission and find the correct commission & premium amount. Example below: I am the insurer. I have quoted a piece of business to...

I thought it was an easy job, but ... I need to name my pivot table according a cell value. I currently type the name manually into the appropriate pivot table options field. But I presume a simple VBA can do the task better. The reason is that when I copy a sheet a couple of times the pivot...

Hello, I am new to the forum. I've been searching Google the past 2 days, but can't seem to get this working. I am using a table, with Nov 2017 - December 2018 in as table headers. I have another column of Est. Closed Date and Net Revenue. I am trying to right a formula that says: IF Est...

Hello all, Please help me with passing a date from a DatePicker, to cell "R5". =EMBED("MSComCtl2.DTPicker.2","") --------> "R5" I looked all over the net but didn't find anything that works... Thank you

Hi Really new to VBA and Macro's so any help would be much appreciated :eeek: I have a spreadsheet that contains data that needs to be pasted to a different worksheet depending on cell value. For instance: <colgroup><col width="116" style="width: 87pt; mso-width-source: userset...

If net income is at least $15,000 and at most $35,000, taxes paid are 28% of income above $15,000, else, If net income is less than $15,000 then taxes paid are 15% of income above $8,000. else, If net income is greater than $35,000, taxes paid are 33% of income above $35,000 B22 is cell...

I have a complex workbook with lots of VBA. I want to create a workbook with one sheet that summarises my main workbook and then make that summary available on the net so I can access it in a variety of ways. Can anyone think of a simple way of achieving this?