View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default Complex functions

Hi All,

Suppose you have a very complex and long function that is also subject to a
condition, then you will/can have something like:

=if(condition(complex function), complex function, other complex function)

It can have more lines in the formula bar, so readability below 0 Kelvin.

Is there a way to 'name' a function?

=If(condition(myfunc = complex function), myfunc, other complex function)




With kind regards,

JP