Nov 24 2017 09:15 AM
Nov 24 2017 09:40 AM
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.