IF function excel (Complex)?

Y/A, as is often the case, has truncated your formula. Try adding a few 'spaces' to it to make it display completely.