View Single Post
 
Old 04-16-2014, 10:09 AM
Gary Drumm Gary Drumm is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

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
Reply With Quote