Nesting IF Statement in excel 2007

[Mezani]

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

 

[Jacob Skaria]

Try the below

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

OR use COUNTIF() for your above condition..

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

 

[Brad]

How about?

=2*(or('EV Assessment'!M43="Second Range",'EV Assessment'!M42="Second
Range",'EV Assessment'!M41="Second Range"))

-- Wag more, bark less