IF/AND Logic
I've been trying to figure out this logic for some time, and would love some help. I attached the sheet below with a simple example.
The first highlighted cell should return the first date, after today, that is over 90%. This would be 5/18.
The lower highlighted cell should return the first date, after the date above, that the percentage is under 90% again. This would be 6/22.
The percentages are variable, and can change from week to week.
Thanks ahead of time!
Last edited by NorthBear; 03-06-2020 at 04:40 PM.
C4=INDEX(A18:T18,MATCH(1,IF(A19:T19>B4,IF(A18:T18>TODAY(),1)),0))
Control+shift+enter
C5=INDEX(A18:T18,MATCH(1,IF(A19:T19<B4,IF(A18:T18>C4,1)),0))
Control+shift+enter
Thank you sir. +Rep and Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks