How to simplify a L O N G functional argument
Go to Menu, Insert--Name--Define
Names in workbook: TheData ---or some other name that you would use
Refers to: =AVERAGE(Sheet1!$D12:$G12) ---use appropriate sheet name of course
Then, for example, in cell H12, I would type the followingw:
=IF(ISERROR(TheData),"No Data",TheData)
--
John C
"Gene" wrote:
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:)
|