compute

  1. H

    Excel function to compute Nominal Int Rate where effective Rate is negative

    I would like to know if there is a function in excel to compute the nominal interest rate if the effective rate is negative If the effective rate is positive the formula =Nominal works perfectly I can however compute this using a mathematical/accounting formula Book1AB1Effective Int...
  2. R

    Time conversion with Vlookup with multiple conditions and criteria before computing the Rate

    Hi Folks, Appreciate your help here, I have few items needed below for my reports and refer to requirements and concerns. Is there a way I can automatically compute the time at B (1st Worksheet) to the corresponding Engineer Grade and Rate per hour base from Engineer name (Section A)? My...
  3. S

    number of days by year

    Hello guys. I am currently facing an issue related to how to allocate the difference between some dates into specific years. Let's assume the period below. <tbody> start_date end_date 03-03-2015 5-06-2017 </tbody> Given this period, I would like to compute the days corresponding to each...
  4. J

    VBA Code Edit to Compute Every Quarter!!

    Hello, I am trying to figure out what I am doing wrong here. I need this formula to calculate the employee quarterly commissions as necessary. This is what I have so far: (if you left click you can download and open the snapshot of my VBA code as it is in Word and not Excel. Anyone have...

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