IF A1 = Yes, then add 1 to B1

**ThanksAlot** · 06-16-2013, 08:51 PM

Hello, and thank you for looking.

I wish to add 1 more to B1, if A1 = "yes."

If A1 = "no," then B1 stays the same.

I copy and past the yes/no everyday to column A.

Thanks, Jon

**Tony Valko** · 06-16-2013, 09:07 PM

Originally Posted by ThanksAlot

I copy and past the yes/no everyday to column A.

To the same cell every day or to the next empty cell in column A?

**ThanksAlot** · 06-16-2013, 09:12 PM

Thanks, Biff, for responding. To the same cell every day. Yesterday B1 = 10, today, it should =11.

**ThanksAlot** · 06-16-2013, 09:13 PM

Yes, to same cell. A1 was "Yes" yesterday, and "Yes" today.

**Tony Valko** · 06-16-2013, 09:27 PM

You'll need a macro to do that.

If you haven't received a solution after a reasonable amout of time (whatever that is?) try starting a new thread in the VBA Programming forum:

http://www.excelforum.com/excel-programming-vba-macros/

**ThanksAlot** · 06-16-2013, 09:32 PM

Thank you.

**Tony Valko** · 06-16-2013, 09:41 PM

This should be fairly easy to do for a real programmer.

Good luck!

IF A1 = Yes, then add 1 to B1

LinkBack

Thread Tools

Rate This Thread

Display

IF A1 = Yes, then add 1 to B1

Re: IF A1 = Yes, then add 1 to B1

Re: IF A1 = Yes, then add 1 to B1

Re: IF A1 = Yes, then add 1 to B1

Re: IF A1 = Yes, then add 1 to B1

Re: IF A1 = Yes, then add 1 to B1

Re: IF A1 = Yes, then add 1 to B1

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions