Thread: Helpneeded in writing special function, "IsBetween"
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
  
Posts: 493
Default Helpneeded in writing special function, "IsBetween"
Oops - dropped the rest of your function:

=IF(OR(A1=B1,A1=C1),"",IF(OR(AND(A1B1,A1<C1),AND( A1<B1,A1C1)),
"Yes","No"))


In article
,
"J.E. McGimpsey" wrote:

Bob - that doesn't do what the OP's function does when A1=B1 or
A1=C1. One alternative:

=IF(OR(A1=B1,A1=C1),"",IF(AND(A1B1,A1<C1),"Yes"," No"))
Reply With QuoteReply With Quote