IF function: add a number if criteria is as required

Hi guys,

If I have cells A2, B2 and C2 populated with the number 5, how can I write an IF statement to say, if the A2, B2, C2 have 5 in each of them, add another 5. This is just a scoring system and if A2, B2 and C2 have 5, a bonus of 5 points is added.

Any help is much appreciated.

thanks!

In whatever cell you require:

=SUM(A2:C2)+IF(AND(A2=5,B2=5,C2=5),5,0)

Try

Formula:

Please Login or Register  to view this content.