mercredi 17 juin 2015

Excel IF AND OR condition together

I am trying to use this formula in excel but am getting an error. Can someone please help?

=IF(OR(AND(B2>=Sheet3!$B$4,B2<=Sheet3!$C$4),AND(B2>=Sheet3!B6,B2<=Sheet3!C6))),"Blue","Grey")

Programmatically, I am trying to get this:

If((a>x && a<y) || (a>x1 && a<y1)){
           Blue
           }
   else
           {
           Grey
           }

Aucun commentaire:

Enregistrer un commentaire