How do I fix the error in my IF AND function that has "maybe" more than two conditions

I am getting an error asking if I am trying to type a formula, but I am not sure what the issue is


Condition 1: K74=Yes
Condition 2: J74 between two dates
If true


I tried making it an ifs function but then I dont have enough arguments

I think the issue that there are 3 conditions not two and the solutions I found online focus on two conditions only.

I also tried putting the commas in different places and using semi colons.

>Solution :

You have to build two conditions for the between-check without joing them as text:


Leave a Reply