Thread: giving me #Value!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
  
Posts: 519
Default giving me #Value!
Hello from Steved

If A5 and B5 is The Same as C5 and D5 then display "dup" please

=IF(LEFT(A5,3)=LEFT(b5,3),"dup","")+=IF(LEFT(c5,3) =LEFT(d5,3),"dup","")

Thankyou

Reply With QuoteReply With Quote