Yes or No Decision Column

December 3, 2014 at 11:14:30
Specs: Windows 7
I need an excel formula to perform the following:

I have 4 columns of activity. If there are any balances at all, I need the cell in a separate column,"Yes/No column" to say "Y". If there is no balance or zero, then the Yes/No column needs to say "N".

Also, I have 3 other columns that if they have a change in balance from the current month from the previous month, need to say "Y" in the Yes/No column. If there is no change, the Yes/No column needs to say "N".


See More: Yes or No Decision Column

Report •

#1
December 3, 2014 at 13:38:03
I'm confused...

You used the words "...the Yes/No column" twice.

Are there 2 Yes/No columns - one for the 4 "Activity" columns and 1 for the "Change in Balance" columns - or only 1 Yes/No column that should say Yes if either of your 2 criteria is true?

In addition, you say that you have "3 other columns" and state that you are looking for "a change in balance from the current month from the previous month". That sounds to me like you are comparing two months - current and previous. You don't need 3 columns to hold 2 values.

Could you please clarify those items for us?

Perhaps an example of your data would help. If you agree, please click on the following line and read the instructions on how to post example data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
December 4, 2014 at 05:08:14
Thank you for responding!

There is only 1 "Yes/No Column".

And, yes, I am comparing the 2nd criteria to a previous month's activity (3 columns in the current compared to 3 columns in the prior month(The prior month is on another tab within the worksheet).


Report •

#3
December 4, 2014 at 09:51:54
Please keep in mind that I cannot see your spreadsheet from where I am sitting, so it's hard for me offer a solution that will match your exact data. As I suggested in my earlier response, perhaps some example data would help.

Checking for "any balances at all" across 4 columns is easy:

=IF(COUNTIF(A1:D1,">0"),"Yes","No")

Basically what this does is start by evaluating COUNTIF(A1:D1,">0") which will count how many cells in A1:D1 contain a value greater than zero. As long as the result of the COUNTIF function is 1 or more, the IF function will see it as TRUE and return "Yes".

As far as your 3-column-month-to-month test, I am having trouble understanding what you are trying to do and when you want a Yes or a No. I need to know what columns you are comparing to what.

I really think some example data - both the input data and the desired output based on that data - would be helpful. Please click on the following line and read the instructions on how to post example data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
December 10, 2014 at 14:46:45
 Tab 1  G        K        L        M       N         O      P     Q     Tab 2   O      P    Q
Y/N $100 $200 $300 $400 $50 $75 $85 $55 $60 $65

Columns K thru Q on Tab 1 equal Y if there is an amount in the columns. + Columns O thru Q on tab 1 equal Y if there value is different than Tab 2 Columns O thru Q.

message edited by RichViv


Report •

#5
December 10, 2014 at 16:31:09
You formatting is messed up so we can't tell what your data looks like.

Please try again.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
December 11, 2014 at 04:59:48
Can I attach the file for you to review? Send an e-mail?

Report •

#7
December 11, 2014 at 06:08:02
You cannot attach a file in this forum.

If the file is emailed then other members of the forum cannot share in the answer or help with a solution.

We would prefer that you format your data per the instructions found via the link below so that everything related to your question is included in the thread.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question