Thread: What's wrong with this IF function.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default What's wrong with this IF function.
Hi,

It's not entirely clear what your trying to do but maybe this

=IF(RIGHT(B1,6)+0RIGHT(B7,6)+0,"","")

Mike

"GEM" wrote:

=IF(B1=MAX(RIGHT(B1,6):RIGHT(B7,6)),"","")
Reply With QuoteReply With Quote