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