| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
| I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
| Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
| Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions | |||
| Custom Header | Excel Discussion (Misc queries) | |||
Threaded Mode
