# Points system with conflicting IF functions

1. ## 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.

2. ## Re: Points system with conflicting IF functions

Hi

Do you mean..?

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

But what if Both conditions are TRUE?

3. ## Re: Points system with conflicting IF functions

that's the one

thanks!

4. ## Re: Points system with conflicting IF functions

You are welcome!

5. ## Re: Points system with conflicting IF functions

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1