Hi guys,
I'm having an issue with one of my formula, I get an error message whenever I press enter. My Excel version is in French and the error message could be translated as "You've typed too many arguments"(not sure if that would be that translation in Excel though).
Here is my formula:
IF(COUNTIF($I$2:$I$894,F4),"YES",COUNTIF($G$2:$G$894,F4),"IN PROGRESS",F4) --> So basically, what I'm trying to do is that if I can find the value of F4 in the range $I$2:$I$894, it should say YES. Otherwise, if I can find the value of F4 in the range $G$2:$G$894, it should say "IN PROGRESS", and if both these conditions are not met, then it should bring the value of F4.
That same formula with only 1 condition: IF(COUNTIF($I$2:$I$894,F4),"YES",F4) is actually working perfectly, but as soon as i try to add another condition, i get the error message.
I'm not sure why this is not working, if anyone can help that would be much appreciated.
Thx
Bookmarks