guy

  1. J

    Count weekends in a row

    Hey guys! I have a table with this format: <tbody> ID Date Day Value 1 31.12.2017 So 7 1 01.01.2018 Mo 8 1 06.01.2018 Sa 9 1 13.01.2018 Sa 8 1 14.01.2018 So 8 1 15.01.2018 Mo 7 2 01.01.2018 Mo 4 </tbody> Now I have this aim: I have a table that lists all IDs. Now I want to...
  2. J

    PMT or the bank?

    I am trying to calculate the monthly installment on a loan of 23000, interest rate of 0.49% monthly, for 12 months. Using PMT I get a value of 1,978.26 but the bank guy tells me it's 2029.37. So who's right?

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