Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote -4 down vote favorite

First Sorry about my bad English.

Here it's the situation, I have:

A1=1   
B1=2     
B2=2

And I want to do an If function so that If B1 = B2 A1 will be 1 + 1, so A1 is now 2. I tried:

=If(B1=B2,A1=A1+1,A1)

but it not working.

share|improve this question
1  
Please elaborate beyond "it not working". Was there an error? Did you get a value? What was it? – Al Everett Sep 30 '12 at 1:15

closed as not a real question by Eight Days of Malaise, Alex, ChrisF♦ Oct 4 '12 at 21:35

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 1 down vote

You can't do that. A cell either needs to be a value or a formula. I would expect a formula in a cell that references the same cell to throw an error for a circular reference.

I don't know what it is exactly that you're trying to accomplish, but you could do something like this:

Simply keep your original value in one cell and the formula in another.

A1=1   
B1=2     
B2=2

Then put the formula for your result in a different cell.

A2=If(B1=B2,A1+1,A1)
share|improve this answer
OK thanks guys. – Hunter95 Sep 30 '12 at 4:03

Not the answer you're looking for? Browse other questions tagged or ask your own question.