I am trying to use an IF(AND statement in excel however it is not working properly. It seems one of the functions does work but the other one does not.
I have tried deleting the AND part of the formula and using only the IF however it still has the same problem.
The code I am using at the moment is:
=IF(AND(COUNTIFS(F10:F15, "=<" & 2000) = 0, COUNTIFS(F10:F15, ">=" & 2000) = 0), "All of the properties were constructed ", "The majority of properties were constructed ")
The main problem is that when all the data shows 2000 or above the formula still shows "the majority of the properties" when it should show "all of the properties". When the data is 1999 or less it does change to "All of the properties".
Aucun commentaire:
Enregistrer un commentaire