IF Statement is not working completly

[asifkhan]

Hi I have following IF statement:

=IF(D2="Identify Programme & Domain","Please Provide P Programme and Domain Names in the Comments Column",IF(D2="Nothing to Do With Us / Talk to … Instead","Please advise if possible of contact details of who can be contacted",IF(D2=“It is Outside P but We are Helping to Deliver”,“No ”,”OK”)))

It works fine for the first two IF statements but third one returns #NAME?

Any help is welcome please.

 

[63falcondude]

Change your quotes from ” to " (slanted to straight).

=IF(D2="Identify Programme & Domain","Please Provide P Programme and Domain Names in the Comments Column",IF(D2="Nothing to Do With Us / Talk to … Instead","Please advise if possible of contact details of who can be contacted",IF(D2="It is Outside P but We are Helping to Deliver","No","OK")))