Forum Discussion

munib ur rehman's avatar
munib ur rehman
Copper Contributor
Nov 24, 2017

multiple rates for range of period

hi every one.. before 30-6-1977 rate was 15%, between 01-07-1977 to 30-06-1991 rate is 10%, between 01-7_1991 to 30-6-1993 rate was 5%, and after 30-6-1993 rate is 0%. Can any body share thoughts on this problem
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Nov 24, 2017

    Hi Munib,

     

    If the problem is to find the rate for the given date when that could be like

    =LOOKUP(A1,{1,28306,33419,34150},{0.15,0.1,0.05,0})

    where the date is in A1. That's for PC, i.e. if the calendar starts from Jan 01, 1900.

     

Resources