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")
with "K24 = H16:H22" are you trying to see if H16:H22 contains K24 ?
If yes, then use match function instead.
Regards,
DILIPandey