Excel Formula query

[Mikey0]

I would like quite a complex formula. I got close to what I wanted but couldn’t quite get it right.

The sheet has a series of columns:
- Date started
- BF date
- Column to state “Checked”/blank to show if cleared, making BF date redundant (but left in for auditing)

e.g.:
A1 - Date started, B1 - BF Date, C1 - Cleared, D1 - Date started, E1- BF date, F1 - blank, G1 - Date started…. and so on

I want formula to:
- Be blank if the cells are blank or the BF date has not passed
- State “Review” if any of the dates in the series of BF date has passed old AND the check column next to that date is clear
- That means, future BF dates OR passed BF dates with checks should not trigger “Review” and if possible state “Ok”
- If possible, start dates with missing BF dates show “No BF”

Summary:
Review - if B is a past date and C is blank
Blank - if all cells are blank, or, if BF date is in the future
Ok - if B is a past date and C has text
No BF - if A exists but B doesn’t is blank
and, this is a series of 3 cells that continues as so l, so any formula should work for ABC EFG HIJ…

Hopefully my description is good enough but if not, I will upload and example. It was fun trying to do it myself at first until it didn’t work Thanks!

 

[kweaver]

You're likely to get help if you (a) change your profile to reflect which version of Excel you are running and (b) use XL2BB to show sample data and expected solution(s).