Thread: AND/OR Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_4_] Phil Hageman[_4_] is offline
external usenet poster
  
Posts: 81
Default AND/OR Formula
I want to add an OR to this formula: if $M4 is a number 1-7, €śtrue€ť results,
and $B6 appears.

=IF(AND(M$4=$E6,M$4<$F6),$B6,"")

Reply With QuoteReply With Quote