Thread: Create formula-if value A falls between values B and C in time for
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Create formula-if value A falls between values B and C in time for
Did you try it?

This will always return TRUE if B1 is entered as a time, since times are
less than 1, and A1+15 is 1

In article ,
"PCLIVE" wrote:

Maybe one way:
=IF(AND(B1=A1,B1<=(A1+15)),D1-A1)
Reply With QuoteReply With Quote