Array formaul with OR condition

T

tonz

Joined
Jan 14, 2009
Messages
1
Reaction score
0
Hi All,

I'm having trouble with a seemingly simple array formula. I am using named ranges and want to just check if on a particular day, if column c > column b OR column e > column d then display "x" otherwise display "ok". It only works for the first date value of the range - after that they appear as false.
Formula is {=IF(Dates=B10,IF(((A>PlanA)+(B>PlanB)>0),"x","ok"))}

Demo workbook is attached and any help would be great
 

Attachments

  • Book1.zip
    2 KB · Views: 59

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

Excel Help with dates 2
How to count array with OR condition 4
[CSE] SUM Array Formula with if condition 1
speeding up calculation: replacing array formula with databasefunction? 9
Number of days in overlapping date ranges (using array formula?) 7
Help with Possible Array or Sumproduct Formula 7
Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible? 10
Problems with using TEXT, INDIRECT and ADDRESS within an array for 10

Top