Solved

excel if statement syntax

Posted on 2016-09-29
6
38 Views
Last Modified: 2016-09-29
Hi experts,

I'm using Excel 2013.

Today’s date is 9/29/2016

In excel the following formula gives me the month part of today’s date. So it gives me 9.
=MONTH(TODAY())

In excel the following formula gives me the year part of today’s date. So it gives me 2016
=YEAR(TODAY())

In excel the syntax for an if statement is like this

=IF(statement,ifstatementistruedothis,ifstatementisfalsedothis)


I'm working on an if statement.
This is the logic for the if statement I need.

If the month part of today’s date equals 1,2,3,4,5,6
           then set the year to 2016
Else  If the month part of today’s date equals 7,8,9,10,11,12
          then set the year to 2017

So far this is what I have. In the part where i put xxx that's the part I need help with.

=IF(xxx=xxx,2016,2017)

Anyone the syntax for the if statement mentioned above?
0
Comment
Question by:maqskywalker
6 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 251 total points
Comment Utility
You'll just replace the xxx=xxx portion with another logic test, like so:
=If (MONTH (TODAY ())<=6,2016,2017)
0
 
LVL 17

Assisted Solution

by:Barry Cunney
Barry Cunney earned 83 total points
Comment Utility
=IF(AND(MONTH(TODAY)<=6,MONTH(TODAY)>=1),2016,2017)
0
 
LVL 31

Assisted Solution

by:Rob Henson
Rob Henson earned 83 total points
Comment Utility
For future compatibility:

=IF(MONTH(TODAY())<=6,YEAR(TODAY()),YEAR(TODAY())+1)
1
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 33

Assisted Solution

by:Norie
Norie earned 83 total points
Comment Utility
Try this.

=YEAR(TODAY())+(MONTH(TODAY()>6)
0
 
LVL 1

Author Comment

by:maqskywalker
Comment Utility
thanks
0
 
LVL 1

Author Closing Comment

by:maqskywalker
Comment Utility
thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now