If A1 equals B1, add 1 to B1?

**magicado** · 06-22-2019, 09:49 AM

I'm trying to make a tic tac toe multiplayer game on Excel for a school assignment, and it's pretty basic but that's all I need it to be.

What I'm trying to do is make a scoring system. Basically, if H1="Player 1 wins!", add one to cell B1. After they click a button to find a score, I want it to be able to lookup two cells and say Player 1 if cell B1>C1, but Player 2 if cell C1>B1. I understand how to do the last part, but the part that I'm finding super difficult is how to get the scores to be recorded in the first place. Every time I try to do it, it comes back with 0 or blank. My current thing I'm using is "=IF('Tic tac toe multiplayer'!H1="Player 1 wins!","M8+1","")", but that's just returning 0. (M8=0, it needed something to add to so I just gave it that, and the cell this is in is the overall score for Player 1)

I've started to get comfortable using macros (but not VBA, that's scary), so if there are any suggestions with that, it would be ok.
Thank you!

**AliGW** · 06-22-2019, 10:19 AM

Welcome to the forum!

As this is homework, we won't tell you the answer, rather just guide you.

In an Excel formula, anything between speech marks is seen as text. Think carefully about what you want to return if the formula returns TRUE - look carefully at that part of the formula again.

On the Formulas ribbon, use the Evaluate Formula feature to step through the formula you have created and see why ity might not be returning what you expect.

**FDibbins** · 06-22-2019, 11:38 PM

Originally Posted by magicado

...I've started to get comfortable using macros (but not VBA, that's scary)...

They are pretty much the same thing

The only way yo have a cell increase in value the way you want, would be to use VBA.

**magicado** · 06-23-2019, 06:01 AM

I was talking about recording macros vs VBA. Recording is something I can do because it's just clicking, but VBA requires all this complicated stuff that I would prefer not to use, but if I have to I will.
How would you suggest I use VBA to do this?

**FDibbins** · 06-23-2019, 11:13 PM

According to google...

Microsoft VBA is the programming language that Excel Macros are recorded in. VBA stands for “Visual Basic for Applications”. With VBA you can create visual basic macros for Excel. ... The truth is that while the Macro recorder is simple to use, it doesn't create nice code and it can only record straightforward tasks.

Is VBA and Macros the same thing?
They're basically the same thing: VBA is the language you use to program macros and functions. I'd guess technically the difference would be VBA code can contain both functions and macros where as a macro code is only the macro part of the code.

If A1 equals B1, add 1 to B1?

LinkBack

Thread Tools

Rate This Thread

Display

If A1 equals B1, add 1 to B1?

Re: If A1 equals B1, add 1 to B1?

Re: If A1 equals B1, add 1 to B1?

Re: If A1 equals B1, add 1 to B1?

Re: If A1 equals B1, add 1 to B1?

Thread Information

Users Browsing this Thread

Similar Threads

If Cell Equals Text Then Cell Equals This Cell *

Counting if 1 cell equals X and another equals Y

if column B equals "cash" then column H equals 0

[SOLVED] if this equals that

if a:a (range) equals january and c:c equals gas then add g:g ($)

[SOLVED] IF equals this OR this

custom filter does not work when selecting 'equals' X AND 'equals'

Bookmarks

Bookmarks

Posting Permissions