There is a bug in my Soup (Formula) !!
- Thread starter arishy
- Start date
Smallman
Excel Ninja
Hi arishy
The Second condition is strong enough to capture the first condition. So where there is a failure in Part 2 it will cover off part 1 as well. So why not scrap part1 and just include Part 2 and Part 3.
=IF(AND(rdate +nDays>=nDate,nDays<>""),"Green","Red")
If my thinking is not correct on this get rid of that second bracket before the , “Green” and it should work a bit better.
Take care
Smallman
The Second condition is strong enough to capture the first condition. So where there is a failure in Part 2 it will cover off part 1 as well. So why not scrap part1 and just include Part 2 and Part 3.
=IF(AND(rdate +nDays>=nDate,nDays<>""),"Green","Red")
If my thinking is not correct on this get rid of that second bracket before the , “Green” and it should work a bit better.
Take care
Smallman
NARAYANK991
Excel Ninja
Hi ,
If I state your conditions in plain English , what you want is that the cell should turn GREEN under the following conditions :
1. If rDate is blank or
2. If rDate is between nDate and ( nDate + nDays )
The only way this can be tested for is by an OR condition , as follows :
=OR(rDate="",AND(rDate>=nDate,rDate<=(nDate + nDays)))
For the RED condition , you can just put a NOT outside the above formula , as in :
=NOT(OR(rDate="",AND(rDate>=nDate,rDate<=(nDate + nDays))))
or you can simplify this to :
=AND(rDate<>"",OR(rDate<nDate,rDate>(nDate + nDays)))
Narayan
If I state your conditions in plain English , what you want is that the cell should turn GREEN under the following conditions :
1. If rDate is blank or
2. If rDate is between nDate and ( nDate + nDays )
The only way this can be tested for is by an OR condition , as follows :
=OR(rDate="",AND(rDate>=nDate,rDate<=(nDate + nDays)))
For the RED condition , you can just put a NOT outside the above formula , as in :
=NOT(OR(rDate="",AND(rDate>=nDate,rDate<=(nDate + nDays))))
or you can simplify this to :
=AND(rDate<>"",OR(rDate<nDate,rDate>(nDate + nDays)))
Narayan
SirJB7
Excel Rōnin
Hi, arishy!
Give a look at the uploaded file. Now date is in A2 cell, no. of days is in B2 cell (7), reference dates are in range C2:C92 (last empty), and results are in range D2: D92 and they seem to be right according to your formula, so there's no bug in it, unless it's an elephant that I don't happen to see.
Regards!
Give a look at the uploaded file. Now date is in A2 cell, no. of days is in B2 cell (7), reference dates are in range C2:C92 (last empty), and results are in range D2: D92 and they seem to be right according to your formula, so there's no bug in it, unless it's an elephant that I don't happen to see.
Regards!