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"))
Actual sheet:- No Case Status Date Created Expected Closure Date Closed 1 3095 Open 03-Dec-14 02-Jan-15 03-Dec-14 2 3096 Open 02-Dec-14 01-Jan-15
3 3097 Open 03-Dec-14 02-Jan-15 04-Dec-14
Aucun commentaire:
Enregistrer un commentaire