fee

Assalam o Alaikum ( May Piece Mercy and Blessing of God on You) How to find with the help of formula between 3rd & 5th Dash ( Red Colored ) <colgroup><col></colgroup><tbody> MUHAMMAD SABEEL AFRIDI - Sem-1 - MSEM-F2017 - R.No.MS 48-2017 UMER FAROOQ - Sem-1 - MSCS-F2017 - R.No.MS 49-2017 Fee...

Hi guys, I have this problem and cannot solve. So I was hoping on some help. I can solve this problem with goal seeking, but this is not dynamic. Maybe you have a better solution. So I have the following: <tbody> <tbody> Total budget </tbody> <tbody> campaign1 </tbody> <tbody>...

<tbody> GRN name Tuition Fee Computer Fee 25 AAAA 11000 1000 30 BBBB 10000 31 CCC 10000 1000 </tbody> <tbody> Head GRN Amount Tuition Fee 25 11000 Computer Fee 25 1000 Tuition Fee 30 10000 Tuition Fee (manually) 31 (manually) ? (Automatecally) </tbody> What...

Hi there, I have been coding for a while so know the basics fairly well. I have, however come across an issue (Code is posted below). I am trying to write a macro where it will create a new sheet, name it and do some basic stuff but then i want it to loop through any other worksheets available...

Hai, I need help on this, as per below table, how to use formula in power pivot or power query. What i need, fee per month automatic in the particular column if the start period and period end between the particular column. example item 1, the fee 50 per month, and start period from Feb 17 to...

I want to prepare a SUMMARY page that finds a corresponding ITEM# on the Summary page within the other 6 worksheet. The ITEM# will appear on ONCE on a single workbook and they will NOT be in alpha/numeric order (so LOOKUP/HLOOKUP/VLOOKUP won't work). The formulas needed will need to match the...

Good morning all! I am working on an Invoice reporting tool and I have everything I need done, I think, except I cannot figure out how to return a variable in Column G. What I'd like to do is return the late fee amount but how I'd like to set it up is for 5% or $35, whichever is greater. I...

I am using the below formula to try and match values with a given fee percentage. =IF(C4<b8,c4*c8),if(c4>=B10,C4*C11),IF(AND(C4<b9,c4>C8),C4*C9),IF(AND(C4<b10,c4>C9),C4*C10) The result is #value ! Thank you for your help.</b10,c4></b9,c4></b8,c4*c8),if(c4>

Hi, I inserted a formula into a macro to start in cell H2. It worked in my test sheet, but in the working sheet nothing happens. Please tell me what I'm missing! The formula to go into H2 and copy down is - =IF(T2<>110,"Incorrect amount billed; to be investigated. Comp fee...

https://imgur.com/a/WsMJj Hi all, Above is a screenshot of the sheet that I am using to calculate payments. I want to put a formula in B13 that automatically works out the weekly fee that each client has to pay. The weekly fee is determined by the total number of orders (cell B4) and you can...

Hi all, I created a function to calculate a value to be returned from a matrix in a sheet. The function is below As you can see I have tried to break it down to find where the error lies. If I use =IF(C126="Investment",introrate(A126,C126,D126,I126),introrate(A126,C126,F126,I126)) as the...

Hi guys, Having a bit of a brain fart today and cannot get my head around this.. I want to be able input a COST (what it costs me) into lets say A2 I then want to be given a PRICE of what I should sell it for.. Fee's that are incurred are: 9% eBay Fee + 20% on top of that for VAT (so 10.8%...

Hi everyone, I have a spreadsheet in which I want to assess a fee if the region is "NORAM". The fee will be 1% of the payments made or 1000, whichever is greater. There is something wrong in my statement because no matter which region I choose the 1,000 fee is being populated as opposed to...

Hey guys! Been busting my head trying to do something in Excel; but haven't been able to reach a satisfactory procedure. So here's the case, on bullets: 1) We have to open a fund to handle our investments. Each fund has a cost of $15,000 for opening, and each one can handle twenty investments...

<colgroup><col><col span="2"><col><col><col><col><col></colgroup><tbody> G/L - Expense Account Title GR No Invoice Date Name Period Class Amount 1001 Admission Fee 12 2-Aug-17 Alizay Ali ------ 2 25,000.00 1007 Computer Fee 12 2-Aug-17 Alizay Ali Aug/ Sep 2017 2...

I need to break up/spread out the information from cell J in worksheet #1 to cells CS through CX on worksheet #2. The information in cell J is similar to the following: 'For resolution unit 6/5/17 regarding activation fees for video group plus, Brandon PLUS negotiated savings $24,272.66 and fee...

After more Googling and experimenting then I care to discuss, I have run into a brick wall attempting to create a formula that can help me through my objective. I found a few threads with similar questions, but no answers, so am hopeful someone can provide direction. I am comparing several...