Same result. I changed the logical test with an integer for easier reading.
=IF(AND(Z5>4,Z5<9),1,"")
The error code is:
"There's a problem with this formula.
Not trying to type a formula?
When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula:
• you type: =1+1, cell shows: 2
To get around this, type an apostrophe ( ' ) first:
• you type: '=1+1, cell shows: =1+1"