multiple rates for range of period

Copper Contributor
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
1 Reply

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.