parse error with nested If

[ayush_mishra]

I am getting parse error message while using nested IF formula and not able to determine what is the error. Please assist.

Formula looks good so far until I add an apostrophe (see 2nd screenshot) but I believe that's not the issue (see screenshot 3 and 4).

Screenshot 1:

Screenshot 2:

Screenshot 3:

Screenshot 4:

And when I execute, I get following error

[BrandonB]

Is it possible that your # of days column isn't a numeric data type? Try checking if it is a double with a select tool. 

[grazitti_sapna]

Hi @ayush_mishra,

It would be great if you could share some sample data, it would help us troubleshoot your problem better.

[Qiu · Accepted solution]

@ayush_mishra 
The error message shows that the expression#2 is having the error.

I tested on my side, that there is no issue with the formula in your Snapshot#2.

So most likely, your '# of Days' is not numeric?

[ayush_mishra]

hi @BrandonB , yes that was the issue. thanks!

[ayush_mishra]

hi @grazitti_sapna, issue was because of incorrect data type, now resolved. thanks for responding.