1.5%

  1. V

    IF conditions returning a % sum

    So I'm creating a spreadsheet to track commission pay-out across multiple pools of business. I want to minimize the risk of my staff doing the % sum themselves but I cant figure out how to use the =IF function. The problem I have is that the commission is different based upon what is sold. For...
  2. M

    Calculate PMT with rising principle

    How can I calculate the monthly payment required to save for an item with a current cost of $10,000 rising at 5% @ year with 1.5% inflation and receiving 10% on the saved funds?
  3. A

    Calculating Current Streak

    Hello, I'm looking to calculate the current streak of either above 0% or below 0%. Here are a few lines of my data below and in the right most column I'd like for the cell to output the number of consecutive wins/losses. The streak needs to end with the left most column (L12 Week12). Can...
  4. K

    Merging formula!

    My main problem / lack of knowledge with Excel is getting formulas that look at multiple things to work. I really struggle with it... I've got 2 different formulas, but have no idea how to make it work as one... data is as follows: <tbody> A B C D E (Chris) F (Joe) 1 05/01/17 Joe 1%...

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