| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a macro/function in an excel spreadsheet (Help)
Glad to help. You will note that this still allows a REAL zero.
-- Don Guillett SalesAid Software "Keith (Southend)" wrote in message ... Don Guillett wrote: You could use =IF(COUNT(A1,D1,T1)=0,"",MIN(A1,D1,T1)) Yes, that does the job superbly. I can add "-" or "x" and that's what it returns. :-) I can also have as many or as few cells in the combinations. :-) Change MIN to MAX where required. This is great. Many thanks again, much appreciated :-) -- Keith (Southend) http://www.southendweather.net e-mail: kreh at southendweather dot net |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Linked Spreadsheets in Excel 2003 | Excel Discussion (Misc queries) | |||
| Selling & Protecting An Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Rotating excel spreadsheet for use in photoshop/ using diamond cells tia sal2 | Excel Discussion (Misc queries) | |||
| Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
