When I write the following simplified command in a cell,


it does not appear the value of the cell D2 but zero, depsite the fact that the 2 assuptions of IF(AND) are fulfilled!

Do you have any idea about what could be causing the problem?

1 Answer 1


Your value type in D6 might be a number and you might be comparing it with a text value, try removing the quotes around the number 30. This might solve your problem. (I don't have excel around).


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .