Forum Discussion
Solved
Discrepancy between function Argument and cell display
When I type =IF(OR(K24 = H16:H22),"","<-- MUST BE A, B, C, D, E ,F or G") in cell L24 of Music Notation tab, the function Arguments window return correct formula result but the cell gives #VALUE. ...
Yes, that could be
=IF(ISERROR(MATCH(K24,H16:H22,0)), "<-- MUST BE A, B, C, D, E ,F or G", "")
or
=IF( (K24>=H16)*(K24<=H22), "", "<-- MUST BE A, B, C, D, E ,F or G")
I have actually the same problem but with the MATCH function. The function argument window shows the correct result (2), but in the cell I get #VALUE...
You need to array-enter the formula: press ctrl+shift+Enter instead of just Enter.
The Function Evaluator (and Evaluate Formula) always behave as if the formula is array-entered. Consequently, they might work when a normally-entered does not.
In the future, please post a new inquiry instead of piggybacking an old posting, especially one that resolved 5 years ago.
