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
|