fee

Hi there! I am stumped. I run a Christmas Caroling Business. In row 1, I have a running total of each singer's pay. My table starts at row 2. Headers are as follows starting in column A (cell A2) DAY DATE EVENT TIME DEPOSIT BALANCE DUE TOTAL FEE OTHER COMMENT PAY SOPRANO (COLUMN L) ALTO (M)...

Hello, I have a VBA script that pulls data from a transaction/order history sheet and assigns them to an individual sheet for each subject. My problem is, as the script is running through the transaction/order history sheet and hits on the right conditions it should copy to the new sheet, it...

I am currently trying to figure out how to do the formula to auto determine a fee. Basically, I have a cell with the total costs of a project, "E44" In a new cell, I want to put the fee determined on that total. Fee structure is a follows: $1 - $25,000 = 6% $25,001 - $100,000 = 5% $100,001 -...

Hi We have originally added fees to accounts based on a percentage of the original balance. We have a new client who wants their fees capped to specific amounts. I've done the formula for the new cliwnt but I'm struggling to add the equation to the original equation. The data looks like this...

First of all here is my function; =IF(A7<>"",IF(COUNTIF($A$7:$A$33,A7)>1,"0.00",$D$4),"") This formula pulls adds a fee (cell D4) when you sign in, and SHOULD allow a sign out and not add a duplicate membership fee. This is meant for column B, is it blank when the parallel cell in column A is...

<colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> A001 1 AC FEE 20.00 A001 1 MEDIA 16.89 A001 1 PROJ M 39.42 A001 1 M FEE 10.12 I want a sumifs with a multi conditional...

Okay, so I have a table with the following sample info. In column A I have an ID. There could be multiple duplicates or there could just be one. These IDs will run from cell A5 to probably no more than A10000. I have another column for a fee that is charged to each ID. If there are...

Hello, Can you help me with the following. In excel I need to calculate how long somebody stays and a apply a different fee. between 1 and 7 nights 1,5 euro between 8 and 14 nights 2,1euro longer then 15 nights longer no extra charge. do you have an idea? please no vsb.. thanks alot

am a beginner in access using access 2010, I am trying to build a database of our church, we are more than 500 families and total members are above 1330 persons. <!-- accessforums, first post, 728x90, green style --> <ins class="adsbygoogle" style="width: 728px; height: 90px; display...

I am trying to write a formula that will apply different rates if a certain cell is a Y or a N -----the 2 rates to apply are: *Focus Funds = 55% of AMF OR **Architecture Funds = ("A std") + ( "A mgmt fee" x 20%)

Hi Guys, I Need some help with regard to when certain cells have value and return to colour-shaped Status: I have 2 different workbooks: one indicating: <tbody> Jan </tbody> <tbody> <tbody> Serial number </tbody> Process fee Registration fee process cost Registration cost...

Hi Excel Gurus, I am currently working on a Project that requires me to look up the respective value: Here is how it goes, I have got 2 workbooks, one is the master workbook that contains data such as: Workbook 1 <tbody> Serial Number Contract fee Maintanence fee Contract cost Maintanence...

I'm not sure why this is stumping me but I've been struggling to find the right solution to solve for the following. I have a table of data that is used to determine cancellation percentages based on a number of factors. The first factor is the "Position Assignment" (found in column U) and...

I'm a student at Macquarie Uni and trying to solve a problem relating to project finance. I'm unable to understand how to solve for Refinance Upfront fee. My lecturer states the following "The refinance fee should be calculated on the refinanced amount, inclusive of the drawdown for the...

Entry <tbody> Admission Fee Security Deposit Tution Fee Computer Fee Total Amount Paid Date 25000 25000 20000 2000 72000 2/25/18 0 25000 11000 1000 37000 3/1/18 25000 25000 22000 2000 74000 2/15/18 </tbody> Report <tbody> Head Feb Mar Admission Fee 50000 formula required Security...

I am using the following formula to round costs to fit into their relevant fee structure...

I am trying to nest 8 IF formulas and can't figure out how to do it. I have the 8 individual formulas working (see below), but can't combine then in a single cell. I'm using MS Office 2013. =IF(AJ6="SM STD",'AMZ Fee 2-22-18'!$B$5) =IF(AJ6="LG STD1",'AMZ Fee 2-22-18'!$B$6) =IF(AJ6="LG...

Hi - Can anyone help me figure out how to calculate total gross on the table? I would like it to calculate $100,000 in first column, $22,500 in second, and $20,000 in third. <colgroup><col width="206" style="width: 155pt; mso-width-source: userset; mso-width-alt: 7533;"> <col width="143"...

Hi, I know it's Monday and I keep hitting a wall to calculate my selling price. I am trying to come up with a selling price where I can factor in all my costs and still make a 10% profit. The problem is I pay a 15% hosting fee based on the selling price I list, I want to make sure I am...

<tbody> Fee Structure Admission Security Tution Fee C.Fee 25000 25000 10000 1000 </tbody> <tbody> A1 B1 C1 D1 E1 F1 G1 Admission Security Month 1 Month 2 Tution Fee C.Fee Total 25000 25000 Aug-17 Sep-17 20000 2000 72000 25000 25000 Aug-17 10000 1000 61000 manually enter...