| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to simplify a L O N G functional argument
I have the following function (this is a "simple" example):
=IF(ISERROR(AVERAGE(D12:G12)),"No Data",AVERAGE(D12:G12)) I don't want to retype, the "AVERAGE (D12:G12)" argument, can I use a "define name" to replace this functional argument? (here in a very simple format) THANKS! Gene:) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using + and / as characters not as functional formatting | Excel Discussion (Misc queries) | |||
| Excel 2007 Nearly Non Functional | Excel Discussion (Misc queries) | |||
| Fully functional spreadsheets on web? | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Non-functional Popup Menu Boxes | Charts and Charting in Excel | |||
Threaded Mode
