View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
 
Posts: 90
Default What's wrong with this IF function.

=IF(B1=MAX(RIGHT(B1,6):RIGHT(B7,6)),"","")