Results based on matching fields

Hi
I wonder if someone can help me with the following.
I want to give result based on criterias.

if A1 = C1 and B1 = d1, then 3, else 0


its quite simple, but i cant make it work.

=if(and(a1=c1,b1=d1),3,0)

Try this

Punnam

hi.
doesnt work :-(
I have tried this earlier but no good result.
Error says error with formula

i have format the cells as numbers

this works fine
=IF(A1=B1;3;0)

but thats only one criteria.

I use excel 2010

Hi,

better provide sample workbook with no confidential data .

Punnam

here is the workbook.
What im trying to do is to set points based on correct result in e.g J3, baed on results in f3=h3 and g3 = i3. if match, then set 3 points

Formula:

Please Login or Register  to view this content.

Hi,
One question what if column F & G or H or I has no value what has to be happen ?.
If it should display Null or Empty use the below formula
Formula in J3 =IF((F3:I3)>0,IF(AND(F3=H3,G3=I3),3,0)," ") activate this using Ctr+Shift+Enter

Punnam

ahh, thanks. so the semicolon fixed the problem :-)

Thanks for grat help

Originally Posted by Saarang84

Punnam's formula doesn't work...

It is working fine in my sheet can u explain me y it is happening ?

Punnam

@ Saarang84,

Thanks for correcting me.

Punnam