"IF" "THEN" formula help

[mxtoys]

cell C4=

(if C3=C1 then sum = 15 otherwise 0) and or + (if C2=C1 then sum = 15, otherwise 0)

so if 2 matches then 30, if 1 match then 15, no match = 0

it is essentially a number matching yes = 15 no = 0 but from multiple cells

the cell entries are never constant but the formula will be.

I hope I explained that clearly enough

Thank You in advance for any help.

2 examples as if in a row in individual cells: 3 3 5 15(the 15 is because the 3 matched the 3) 3 4 7 0(the 0 because no matches)
3 3 3 30(the 30 because both 3's matched the 3)

[mikeTRON]

Can you post a sample workbook with those examples and a hard coded solution so we can see exactly what you are trying to accomplish??

[Ace_XL]

Try in Cell E1

=countif(B1:D1,A1)*15

Where cell A1 to D1 holds your data

[mehmetcik]

Please Login or Register  to view this content.

[mxtoys]

Perfect !!!! I tested it

Thank You !!

sure looks pretty easy, I should have researched more.