Formula if/then and looking forwad - Please HELP

L

Lisa

I have several years of daily data and I'm trying to determine if a daily
goal was met based on several criteria.

1. If column b =>15 "goal met"
2. if column b is <15 has a zero or looks blank then look forward 6 cells
and the first two cells that have data are both => 15 "goal met" if not "not
met"
3. If column b is blank and after looking forward 6 cells and the resuls are
still blank the results should be "absent"
 
M

Max

One shot at this
Try in C2:
=IF(B2>=15,"goal met",IF(SUMPRODUCT(--(OFFSET(B3,,,6)>=15))>=2,"goal
met","absent"))
Copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Help 2
Count Blanks 4
Formula help with averages and if then statements 1
Complex formula help , please. 13
Data Validation and drop-down list using IF, AND and what else? 8
Get data if cell within a row meets criteria 2
vb code question 8
And then there were ZEROs... 7

Top