Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Having problem with this syntax statement. Syntax doesn't error, but I get a false response when any month is not FEBRUARY. =IF(INPUTSHEET!C1="FEBRUARY",IF(INPUTSHEET!C4="Y","29","")) I'm trying to get "29" in any month that isn't February and only regardless of Leap Year, the "Y" in INPUTSHEET!C4 is = Leap Year.
Solved by T. Q. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/12/2017 - 01:20
Hello, welcome to got it pro
Excelchat Expert 12/12/2017 - 01:21
you there?
User 12/12/2017 - 01:22
yes
User 12/12/2017 - 01:23
yes
Excelchat Expert 12/12/2017 - 01:23
You are getting false because of the format if IF function
Excelchat Expert 12/12/2017 - 01:24
In your case, if C1 is anything other than "FEBURARY", you will get FALS
Excelchat Expert 12/12/2017 - 01:24
as ouput
Excelchat Expert 12/12/2017 - 01:25
What do you want as output?
User 12/12/2017 - 01:25
"29"
Excelchat Expert 12/12/2017 - 01:26
Ok, so if C4 is anything other than FEBURARY
Excelchat Expert 12/12/2017 - 01:26
output should be 29
Excelchat Expert 12/12/2017 - 01:26
right?
User 12/12/2017 - 01:26
correct
Excelchat Expert 12/12/2017 - 01:26
=IF(INPUTSHEET!C1="FEBRUARY",IF(INPUTSHEET!C4="Y","29",""),29)
Excelchat Expert 12/12/2017 - 01:27
Let me know if you have any query
User 12/12/2017 - 01:28
one second, thanks.
Excelchat Expert 12/12/2017 - 01:28
Anything else ?
User 12/12/2017 - 01:29
No, thanks, it worked fine. Appreciate the help. Have a great day!
Excelchat Expert 12/12/2017 - 01:30
Welcome
Excelchat Expert 12/12/2017 - 01:30
Please leave your valuable feedback :)
User 12/12/2017 - 01:30
NP
Excelchat Expert 12/12/2017 - 01:30
You may close the session now from above :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.