Excel IF Function nesting not working

Question

I am creating a series of nested IF functions and I want the function to look like this: =IF(F3="M","N",IF(D3<6,"N","Y")) 

I want it to work as: IF F3 says "M" then say "N" in this cell (G3), if false, then if the months (which is cell D3 in X Months, X Days) are less than 6 than "N" otherwise "Y".

I'm not sure if the nesting isn't correct or if it is the fact the D3 cell is in months and days. It seemed like it was correct before, but the combined functions weren't in all of the cells so it was only partially working. 

In addition, autofill will no longer let me drag my function down when it was working fine before. 

Thanks.

Answer 1

Formula is correct... it needs a number in D3.

It appears from your post that D3 contains something like 6 months and 2 days.

If that is the case then you need to extract the number of months using

LEFT(D3,FIND(" ",D3))

You then need to multiply it by 1 to convert to a number and use in your IF formula.

Complete formula is given below

=IF(F3="M","N",IF(LEFT(D3,FIND(" ",D3))*1<6,"N","Y"))

Answer 2

It seems to be working now. I'm not sure what changed haha.

Answer 3

Hi SkyeDemi

Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

When you say - In addition, autofill will no longer let me drag my function down when it was working fine before.

What is the exact issue here. Is AutoFill handle not working?

Answer 4

Worked perfectly with the FIND function and multiplying by 1. Thank you!!