Formula

[mdz369]

I have written the following formula

=IF(A2=10, B9+1,IF(SUM(A2+B2)=10,B10+1))

Basically what I want it to do is increase the value of B9 if A2 equals 10 and increase the value of B10 if A2 and B2 equal 10.

I know I have not written it correctly so I wonder if someone could help me out with this?

Thanks

 

[kidwispa]

I have written the following formula

=IF(A2=10, B9+1,IF(SUM(A2+B2)=10,B10+1))

Basically what I want it to do is increase the value of B9 if A2 equals 10 and increase the value of B10 if A2 and B2 equal 10.

I know I have not written it correctly so I wonder if someone could help me out with this?

Thanks

Try

=IF(A2=10,(B9+1),IF(SUM(A2+B2)=10,(B10+1)))

 

[Aladin Akyurek]

I have written the following formula

=IF(A2=10, B9+1,IF(SUM(A2+B2)=10,B10+1))

Basically what I want it to do is increase the value of B9 if A2 equals 10 and increase the value of B10 if A2 and B2 equal 10.

I know I have not written it correctly so I wonder if someone could help me out with this?

Thanks

Where did you put this formula?

 

[mdz369]

In a random cell. I just want it to add +1 to cell B9 or B10 when the criteria is met

 

[Aladin Akyurek]

In a random cell. I just want it to add +1 to cell B9 or B10 when the criteria is met

E2:

=IF(A2=10, 
      B9+1,
      IF(A2+B2=10,
        B10+1,
        0))

Is this what you meant?

 

[mdz369]

That works yes but what it does is increase the value of the cell the formula is in by 1 and not the cells that I want.

 

[CharlesChuckieCharles]

=IF(A2=10,(B9+1),IF(SUM(A2+B2)=10,(B10+1)))

This is very confused which column needs to be incremented ?

 

[mdz369]

B9 needs incrementing if the value in A2 on its own is 10 whereas B10 needs incrementing if the combined total of A2 and B2 are 10

 

[CharlesChuckieCharles]

So what is the current value of B9 or B10 whats actually in the cell?

IN B9
=IF(A2=10,1,0) will give you 1 or 0 in B9
in B10
=IF(AND(B9=0,SUM(A2+B2)=10),1,0) will give you 1 or 0 in B10

you can't have a Cell with a formula and a value, and you can't have a cell increment itself, it has to reference something else

B8 = 34
B9 = B8+1 which is value of B8 +1 (35)

 

[Aladin Akyurek]

That works yes but what it does is increase the value of the cell the formula is in by 1 and not the cells that I want.

The formulas cannot change a cell other than where it is entered.