I am trying to do an if statement on a second sheet, there are three cells
that have the same drop down list in it. I tried this bu am getting an error.

=IF('EV Assessment'!M43="Second Range",2,0,IF('EV Assessment'!M42="Second
Range",2,0,IF('EV Assessment'!M41="Second Range",2,0))))

I tried it with three and four parenthesis at the end and no change.

Thank you