+ Reply to Thread
Results 1 to 4 of 4

If date is within 1st 10 days of month, apply 1+x% percentage, otherwise apply 1+y%

  1. #1
    Registered User
    Join Date
    03-25-2020
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    53

    If date is within 1st 10 days of month, apply 1+x% percentage, otherwise apply 1+y%

    Hello

    Depending on period in month, I'd like the data in Data to be uplifted by doing the following = data value * (1+ (a portion of Adjustment Assumption for the month and country in question))

    If data's date is within the first 10 days of the month, apply 1 + (80% of Adjustment Assumption for month and country in question)
    If data's data is outside of the first 10 days of the month, apply 1 + (20% of Adjustment Assumption for month and country in question)

    So instead of applying a flat rate assumption for the whole month, I want to split it in two lots, one view for 1st 10 days of the month and another view for remainder of the month. Because the behaviour is different throughout the month, so a flat rate adjustment wouldn't make sense.

    For example = Germany for October is showing 4% Adjustment Assumption. If date is within first 10 days of October, than data for that date should be increased by multiplying the data * (1+ (80% of 4%)). If date is outside of the first 10 days of October, data * (1+(20% of 4%))

    Want the final result to be shown in the first tab, Adjusted Data

    hope that kind of makes sense!
    Attached Files Attached Files
    Last edited by losincog; 09-25-2020 at 08:35 AM.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,026

    Re: If date is within 1st 10 days of month, apply 1+x% percentage, otherwise apply 1+y%

    If I understood correctly this might work in E6 dragged down and across. Check it though as you didn't give an exact solution for me to confirm this works as you expect.

    Please Login or Register  to view this content.
    for some reason the file wouldn't upload with all cells populated with the formula so this version I've only populated the first few rows and columns. Drag across and down to complete
    Last edited by Crooza; 09-25-2020 at 08:06 PM.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,545

    Re: If date is within 1st 10 days of month, apply 1+x% percentage, otherwise apply 1+y%

    Cell E6:

    Please Login or Register  to view this content.
    Drag down and accross

  4. #4
    Registered User
    Join Date
    03-25-2020
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    53

    Re: If date is within 1st 10 days of month, apply 1+x% percentage, otherwise apply 1+y%

    thanks, changed my layout since as wanted to show the adjustment values separately but essentially used a mix of the above, stripping out the 1 of course

+ 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. [SOLVED] VB Code to apply random percentage in numbers
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2018, 02:50 PM
  2. [SOLVED] Apply VBA Script based on Text in one column and apply a formula in another column
    By vvincent in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2016, 09:19 PM
  3. Apply percentage based on number range and criteria
    By Navyguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2016, 08:58 AM
  4. [SOLVED] Check Prices and apply markup percentage Formula
    By Bash66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2014, 09:38 PM
  5. How to apply a percentage formula across multiple cells/single worksheet
    By Hooliegirl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2013, 09:20 AM
  6. [SOLVED] VBA to split data and apply a percentage sum to total values
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 72
    Last Post: 08-01-2012, 08:45 AM
  7. Apply Percentage to Entire Worksheet
    By joesmithf1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2007, 01:28 AM

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