Results 1 to 4 of 4

Is a single formula better than intermediate calculations?

Threaded View

David Huang Is a single formula better... 02-02-2010, 08:08 AM
DonkeyOte Re: Is a single formula... 02-02-2010, 08:19 AM
teylyn Re: Is a single formula... 02-02-2010, 08:20 AM
David Huang Re: Is a single formula... 02-10-2010, 10:23 AM
  1. #1
    Registered User
    Join Date
    01-12-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    16

    Is a single formula better than intermediate calculations?

    I've used Excel for a while, but I am new to forums.

    What's been a real eye-opener for me is that the solutions posted are not the way I would have approached the problem in the past.

    I come from a (procedural) programming background, where we perform operations step by step. I tend to use intermediate calculation columns, with only 1 or 2 calculations per formula, or, failing that, use a UDF. I find this easier to debug and maintain.

    The solutions I see tend to give the result in one formula. This reminds me of the functional progamming languages I used years ago.

    I'd like your opinions on what is best-practice, or common practice, in relation to constructing formulas, so that I can improve my development.
    Last edited by David Huang; 02-10-2010 at 10:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1