Nesting IF Statement in excel 2007

  • Thread starter Thread starter Mezani
  • Start date Start date
M

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
 
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)
 
How about?

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

-- Wag more, bark less
 
Back
Top