Microsoft EXCEL formula/programming help?!?!?

Question

trying to run a simple if value inside cell = x, then y=y+1?? any little help will help a lot.

Answer 1

If you're trying to count the number of times 'x' is entered into a cell, you can't do that because it requires a circular reference. Placing:
=IF(A1="x", B1+1, B1)
into cell B1 will produce an error.
You could count the number of times 'x' is entered in a range of cells:
B1:
=COUNTIF(A:A,"x")
counts all occurances of "x" in column A
=COUNTIF(A10:A33,"x")
counts all occurances of "x" in column A from row 10 through row 33

Answer 2

Lemme wager, you're in a working laptop or workstation Literacy type... perhaps with the artwork Institute??? as a results of fact whats humorous is this is the actual query of this weeks first project. weird and wonderful. "Week 3: Week 3 - W3: project a million talk talk query 3 evaluate Microsoft be conscious, Microsoft Excel, and Microsoft PowerPoint. whilst do you need to apply each of those purposes? whilst are you able to apply those purposes interchangeably? supply examples and reasons to help your answer."

Answer 3

excel can be very confusing bit i can c that you know what you are doing when it comes to formulas so i think that you are not supposed to use variables in the formulas.

Answer 4

=IF(A1="x"; Y1+1; "");

=IF(A1="x"; Y1+1; Y1);


=IF(A1="x"; B1+1; B1);