I need a formula that looks to see if a customer filed a claim in year 1. If they didn't AND they renewed (meaning they continued on into year 2) I would like G to return a value of yes.
For example, customer 1, in year 2 renewed (by definition, year 2 is a renewal of year 1) and they DID place claims in year one so the value in G would be NO.
Year 1 is not relevant because it's the first year and there is no renewal decision.
Spreadsheet is attached.
Not exactly sure which year you want to text for the claim, so I took the previous year...
=IF(AND(C6=C5,E5=1),"No","Yes")
If you want it based on the row year...
=IF(AND(C6=C5,E6=1),"No","Yes")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks