From: Mezani on 12 May 2010 01:10 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 From: Jacob Skaria on 12 May 2010 01:26 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) -- Jacob (MVP - Excel) "Mezani" wrote: > 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 From: Brad on 12 May 2010 06:08 How about? =2*(or('EV Assessment'!M43="Second Range",'EV Assessment'!M42="Second Range",'EV Assessment'!M41="Second Range")) -- Wag more, bark less "Mezani" wrote: > 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  |  Pages: 1 Prev: Function Error IF StatementNext: populate month-yyyy when compare 2 cells