Prev: Function Error IF Statement
Next: populate month-yyyy when compare 2 cells
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 Statement
Next: populate month-yyyy when compare 2 cells