Connecting Multiple If with or

[ecelaras]

Hello Everyone ,

I have a problem with connecting multiple if with or ..for example :

=IF(A2=LARGE($A$2:$A$17,1),5,0)+IF(A2=LARGE($A$2:$A$17,2),4,0)+IF(A2=LARGE($A$2:$A$17,3),3,0)

But if the large numbers in any case are the same it will take double values and I dont want that .

Can we put instead of + or ....or anything else .

Thank you

[Pete_UK]

You could do it this way:

=IF(A2=LARGE($A$2:$A$17,1),5,IF(A2=LARGE($A$2:$A$17,2),4,IF(A2=LARGE($A$2:$A$17,3),3,0)))

Hope this helps.

Pete

[ecelaras]

Pete tha helps but when I enter this function =IF(A2=LARGE($A$2:$A$17,1),5,IF(A2=LARGE($A$2:$A$17,2),4,IF(A2=LARGE($A$2:$A$17,3),3,0,if(a2=large($a$2:$a$17,4),2,0,if(a2=large($a$2:$a$17,5),1,0)))))

it pops the message (you ve entered too many arguments )

[Pete_UK]

That's because you have left the ,0 in after the ,3 and the ,2

Hope this helps.

Pete

[ecelaras]

Thanks for the Help Pete !! Works fine now !!