vendredi 27 février 2015

return value after meeting two condition

Can some one help me with the IF Formula. I need an IF formula that will return value of "Open" or "Closed" by evaluating the condition where if I have a cell as below. I need the B3 to be automatically provide status whether open or close after checking Cell A1 if got data and if CellE1 got data then it should return Closed in cell B1 else if the Cell A2 got data but the cell E2 got no data it should return value "Open" in B2.


I tried something like this but didn't work:


=IF(AND(A2,E2=">0"),"Open",IF(AND(A2,E2"<0"),"Closed"))



A B C D E
1 No Status Date1 Date2 Data
2 3133 Open Date1 Date2 Data
3 3134 Closed Date1 Date2 Data
4 3135 Open Date1 Date2 Data
5 3136 Closed Date1 Date2 Data
6 3137 Open Date1 Date2 Data

Aucun commentaire:

Enregistrer un commentaire