Quote Originally Posted by JimmyTheHand
Running the above line I got this formula in the active cell:
=HA('A1'=17;IGAZ;HAMIS)
The result was #NAME? error, until I removed the apostrophes around A1.
Don't know how they got there Nevertheless, the booleans got translated.
As you correctly surmised, it was because I used the FormulaR1C1, but added an A1 formula. I guess Excel puts quotes around the A1 because it is being supplid in R1C1 type formula it thinks the A1 is a name, and you can't have a name that is a cell reference.