Points system with conflicting IF functions

Hi

I'm trying to create a points system as follows:

If Cell A = Cell C, 20 points
If Cell B = Cell D, 10 points
If Cell A = Cell D, 5 points
If Cell B = Cell C, 5 points

I would like to have two cells holding the points. One for the Cell A points, and one for the cell B points. The 5 point scores are like bonus points.

I have managed to get the regular points working using =IF(A1=C1,20,0)) and =IF(B1=D1,10,0)), but I would like to incorporate the bonus points into both formulae. I can work out that (own their own) IF(A1=D1,5,0)) and IF(B1=C1,5,0)) would do it, but they conflict with the existing formulae in those cells.

I hope all of that makes sense.

that's the one

thanks!

Originally Posted by Fotis1991

Hi

Do you mean..?

=IF(A1=C1,20,IF(B1=D1,10,0))

But what if Both conditions are TRUE?

I just noticed your question here - it's impossible for both conditions to be true - it's an either/or scenario.