Forum Discussion
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 t...
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.