Iserror control

M

Mike

Hi all,

Is there a way to shorten a Control Source's text to something more
manageable if the Source is currently

=iif(iserror([really long formula]),0,[really long formula])

Thanks
 
K

Klatuu

Put the really long formula in a function and set the control source to the
function
=CalcRLF(any arguments needed by function)
 
Top