It must be something to do with how the IFS formula works.
See post#4