View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default if a cell = a particular letter or even contains that letter

=IF(M22="all","a",IF(M22="e","r","a"))

Notice the "e", how can I insert the following:

....If m22 contains "e" anywhere,"r","a"))

Thanks

Brian