Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    How to create a 'MegaFormula' (Excel 2000 >)

    Browsing the net, I found this interesting article for creating a "MegeFormula".
    I'm sure it will assist some who have had hassles creating multiple nested functions. The instruction is very clear and logical to follow. It could change the way you think about complex formulas!!!
    Thanx to the author for sharing this "secret".
    http://www.j-walk.com/ss/excel/usertips/tip079.htm
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to create a 'MegaFormula' (Excel 2000 >)

    There are many useful tips on John Walkenbach's site.

    Creating a 'megaformula' can be fun (if your mind is sufficiently warped <img src=/S/grin.gif border=0 alt=grin width=15 height=15>). But keep in mind John's warning that the end result is almost impossible to understand, and hard to maintain. It may be better to keep the intermediate formulas; you can hide them if necessary.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •