I am typing a similar formula to =if(a1="No","Not Applicable",'Data'!a3). But when I get to the A3 Excel automatically moves my cursor to just after the e" and wants to enter whatever I type there. As soon as I click on after the A3 it moves my cursor again. I'm have the same problem when concatenating but using the & to join text and inputs.
