+ Reply to Thread
Results 1 to 4 of 4

Calculate 1st month and succeeding another calculation

  1. #1
    Forum Contributor
    Join Date
    08-24-2009
    Location
    Manila, Philippines
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    120

    Calculate 1st month and succeeding another calculation

    Hello,

    I had a formula before and I tried to edit but I'm struggling. Pls. help me.

    I need to calculate 1st month to bring the first rate and the succeeding month the 2nd rate. If at the end there is a fraction in a month. then multiply the 2nd rate x fraction of the month.

    I attached the excel file for easy understanding.

    Thank you.
    Attached Files Attached Files
    Last edited by rickyilas; 06-24-2022 at 09:31 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Calculate 1st month and succeeding another calculation

    Try

    in BD3

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    copy acroos and down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    08-24-2009
    Location
    Manila, Philippines
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    120

    Re: Calculate 1st month and succeeding another calculation

    Hi John!

    It's Perfect!!! Thanks for your help. It's working for me... Really appreciate it.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Calculate 1st month and succeeding another calculation

    You're very welcome and many thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-14-2019, 08:42 AM
  2. [SOLVED] Get First day of the Month and every Monday of the succeeding weeks within that month
    By juan.doe in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-14-2018, 05:57 AM
  3. [SOLVED] Calculate a YTD Total based on Reporting Month and Week of Month via drop down selections
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2018, 05:14 PM
  4. Row calculation changes each month when data from previous month is deleted
    By SHOOTERTPP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2017, 01:32 AM
  5. month to date calculation based on month selection from list box
    By jamaludheen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2017, 06:00 AM
  6. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  7. Replies: 0
    Last Post: 05-17-2014, 10:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1