fees

  1. K

    Formula for Changing % allocations

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> 3) Using the "Starts" Table, calculate total fees for each project, fee amounts generated each period per project, and total fees. Assumptions: The fee is...
  2. H

    Calculate bank fees

    Hi guys I need a formula to calculate bank fees for purchase using excel, you'll find the fees details in the end of this post, however, my bank balance was 2.87€. The product I bought cost 2.81€. After the purchase was done, I noticed that the bank took out 0.12€ as fees and then my balance...
  3. I

    eBay + Paypal Fees formula

    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%...
  4. E

    Index, match, lookup?

    I am trying to build a spreadsheet whereby I am able to figure out the total effective fees charged to a brokerage account based on the account balance. I know the fees charged for each $X in the account, but I can figure out how to do a "lookup" of sorts, or IF statements, to determine the...
  5. J

    Overcome Nested IF statements

    I have a table as follow on fees and wanted to use the nested IFs to find the accumulated fees depending on which month it is. <tbody> A B C D E F G H I J K L M Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Fees 640 500 800 500 650 420 410 550 220 440 160 180 </tbody>...
  6. T

    Calculating the APY on a Credit Card with Monthly Fees

    I have done a thorough search for the calculation in Excel that gives me the APY for a credit card I have that charges an interest rate of 24.40% BUT also charges me $8.25 per month as one month's cost of the annual fee of $99 - and have found NOTHING. If my balance is $430.38 and the credit...
  7. A

    Custom Formula Question

    Hey peeps, I just have a quick question and I know this is going to sound ridiculously simple and I apologize if it is - I'm a bit new to Excel formulas. My question is this: I'm trying to create a formula that takes into account a certain price, adds fees (percentages + fixed fees + taxes) to...
  8. M

    Calculate eBay BIN price

    Is possible count by formulas eBay Buy It Now price ? My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90 Where is PayPal 3.4% + 20p Ebay 40p listing Ebay 10% Fee Postage £0.9 I need formula where I set my cost...
  9. J

    Need help with vba code searching using an autofilter

    So I have created a spreadsheet where team members can click a button, type in a number, such as 999 into a user form and it will search another sheet that is set up as a table and has an autofilter. I am running into issues with users searching for something that is only one of a kind and then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top