Formula to return the base interest rate on a given date

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:38 PM GMT


I'm trying to find out how to havereturn Barclays Base Rate of interest for a list of dates.

I have the figures for the base rate and the periods for which these figures applied. (In two columns of data: 1) the start dates of each change in the interest rate figure, and 2) what that new figure is)

I also have a list of dates (on a separate sheet)

I would like to be able to havelook at each date, identify which "base rate period" it falls under, and create a new column showing the base rate at that date.

Sorry if my question's unclear. I'll happily give more info if necessary.

Kind regards.




You didn't ask me this question - I found it in the question pool. If you only asked one expert, then you won't get an answer from that person. I can give you an answer, but I would need to see where you lists are and so forth. If you want to send me a copy of your workbook I can furnish you the formulas.

send it to (I can appreciate you might have sensitive information - so if you can just send the sheet with just the Base rates and the second sheet with just some representative dates in the correct locations, it shouldn't take but a minute or two to set up.)


©2024 eLuminary LLC. All rights reserved.