Safer? In this case, it is referencing numbers only.
But can you explain further, and give me a couple of examples of such error values, logical values and arrays?
I don't think I will get in that deep, but what might be an expected outcome?
I'll give the =TYPE()=1 a try.
=((TYPE(H4)<>2)*(H4<>""))*OR(H4<$E4,H4>$G4)
How would apply your suggestion to this formula?
Thanks,
Gary
|