net

I asked a question a while ago about making a list of products and then adding sizes that give a price based on a square metre rate. I have been using this for a while but want to know if I can do this but slightly different. In column A I put the product but on a drop down list. In B we put a...

Hello. I am trying to do a nested IF statement returning a different value if criteria is met. When I use one value to find, it works fine. =IF(FIND("NET A", A2)=1, "NET ASSETS", "") If I try adding additional criteria, it results in an error. =IF(FIND("NET A", A2)=1, "NET ASSETS", ""...

the basic formula I use is this: =SUMIF(A:A,$A$10,B:B) in this example, $A$10 returns "Total Net Sales" and there is a dollar amount in column B but...I need to sum all instances of $A$10 only if the cell 3 spots above each instance = "Saturday" I hope this is clear. the first instance of...

I am trying to remember how to use the conditional formatting function to account for press size vs hourly revenue. For example, if the company is running a 300-400 ton press, it should have a net revenue of at least $50 (hourly). I was wondering if there was a way to just input the press size...

Hi all, kindly advice me for a VBA code so that to run through col. “A” and where find the row which contains text “Deductions” the number in adjacent cell in col. “J” should be minus (-). I present below the original data and the expected result. Thanking you in advance <!--[if gte mso...

please can somebody help me with this date format change formula am trying but cannot find it on the net

Hi John_w, I want to READ the String "TREASURY REFERENCE NUMBER: " when this string found, I want to extract columns, below 14 lines from the string , data in excel.Sample text file , required output in excel sample and the code I am trying is as follows...

Hi, i've been asked to remove a commission amount from a figure to bring it to net, then add in a different commission amount. I can work out all individually but i'm struggling to put it all into one formula so some help would be great! The numbers i have at the moment are as follows; Gross...

I would like to create a worksheet that includes pulls data for each fund, but one fund (i.e. AA Fund) at a time and for Net Purchases for fund total ($6,678.00 as of Oct 1, 2018). I would like to create a table that shows the time series. For example, column A should be the date, 10/01/2018...

Hello, I would need some help with a formula I am trying to build. Please refer to the file in the link as I think it would be much easier to understand what I am trying to achieve. https://www.dropbox.com/s/tt1r2ut325qkzdq/Test.xlsx?dl=0 The formula in cell C1 should evaluate a string in...

Hi, A B C D Starting Balance 120.00 150.00 200.00 Net Cashflow 0.00 -80.00 500.00 Ending Balance 120.00 30.00 700.00 I know I can get the whole row returned {0.00...

I am attempting to understand an NPV/IRR calculation using nested Offset from 2017 to 2027. The formulae are as follows: NPV(C15,OFFSET(D39,0,0,1,C16-1))+C39 Where C15 = WACC, D39 = 2018 net annual benefits, C39 = 2017 net annual benefits & C16 = valuation years IRR(OFFSET(C39,0,0,1,C16))...

I have sumif formulas calculating the net for the month; all of them work except January. January also counts cells that don't have a date at all. The users want to calculate their net before taxes, so the taxes date is left blank so they don't factor into any month. However, January then...

Hello all. I am new to Power Pivot and am taking my first stab at it by uploading multiple data sets that show net revenue received for each company. I am having a difficult time creating a relationship between the net revenue columns for each data set. Instead, I receive an error saying "Net...

Hi all, I have existing data on the left. I need the outcome shows on right? Not sure how to derive it. Can you guys pls help me out? Thanks! <colgroup><col><col span="2"><col><col span="3"><col><col><col><col><col><col><col span="4"></colgroup><tbody> A B C D E F A B...

Hi, can anyone help? I've created a Pivot Chart from my Pivot Table which has columns of :- Description, Invoice Quantity, Invoiced Amount and Net Profit. When I create the Pivot Chart it calculates the Invoice Quantity which is the first value in my Pivot criteria however I want the Chart to...

I have the folowing formula that has twxt within the formula =IF(B25-C25>0,"The Net Profit "&MID(B3,9,25)&" has increased by "&TEXT(B25-C25,"R#0,##0"), IF(B25-C25<0,"The Net Profit "&MID(B3,9,25)&" has decreased by "&TEXT(B25-C25,"R(#0,##0)")&" VS")) I need to amend this to read as...

I’m not sure if this is possible on a pivot table, but I’m hoping if someone knows they could help me out. I have net sales and cost of sales. The material margin is the difference between the two. In our business we like to see it as a percentage. I can either get the sum of the two and...

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...

Hi guys, I'm a relatively basic excel user, and now I'm faced with an issue that I'm sure it's fairly simple to resolve, I just can't figure it out. I have this spreadsheet where I'm given just the name of the passengers, how many days they'll stay and which kind of room they'll use. Also, I'm...