I am trying to write a formula that will return the date at which a loan reaches a $1,500 threshold or less. The formula needs to look at column F, find the first dollar amount less than 1500 and return the date that is on the same line as that value.
My dates are in column B. My Loan Ending Balance is in column F. I figued this would be sooo easy, but I just can't seem to make anything work!
Does any one have an idea for me?
Thanks for any help!
=IF(ISNUMBER(MATCH($A$1,$F$2:$F$50,0)),INDEX($B$2:$B$50,MATCH($A$1,$F$2:$F$50,-1)),INDEX($B$50, MATCH($A$1,$F$2:$F$50,-1)+1))
I put the $1500 in A1 so you can replace $A$1 with 1500 if that's a constant.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Have you considered using a conditional format formula on the date range?
Tom S.↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the leftIf your question is resolved, mark it SOLVED using the thread tools.
YES! I got that to work. You're a genius! Thanks so much! =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks