Thread: How to simplify a L O N G functional argument
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gene Gene is offline
external usenet poster
  
Posts: 100
Default 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:)


Reply With QuoteReply With Quote