View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default How do I write an excel formula with a text answer ("yes" or "no")

I wish to compare a value (number) in a cell with 2 other numbers and arrive
at either a "yes" or "no" answer. Example: If C19 is equal to or more than
C18 , and equal to or less than C17, then the resulting answer is "yes"; If
C19 is less than C18 or more than C17, then the resulting anwer is "no".