View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default Use custom message

The following formula will return TRUE or FALSE. How do I modify it to
return a custom message like:

"Updated" for true
"Not updated" for false

{=SUMPRODUCT(1*(ControlCentre!$C$77:$C$1000=Purcha ses!BM25))0}

Much appreciate any help.

Pat