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.