**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.*