MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Aladin - > useage of CSE


Posted by Chris D on December 13, 2001 11:29 AM

Hi Aladin,

as with, say, message 9783, how do you know when or when not to use CSE formulae ?

is it just a preference and experience thing, or is there any black n white logic ?

As an aside, I went on an advanced Excel course a few months ago but have learned more in 4 weeks from this website than from any other scource in the last 6 years !!! Thanks for your patience, commitment and unbounded willingness to share

Chris D
:-)


Posted by Aladin Akyurek on December 13, 2001 1:55 PM

Hi Chris --

> as with, say, message 9783, how do you know when or when not to use CSE formulae ?

Almost all situations in which 2 or more conditions (as in message 9783) must determine the outcome can be solved with CSE or SUMPRODUCT formulas. Note that there are also other means which can be used such as database functions if they fit.

Some functions require CSE because vector or matrix multiplications are needed for required computations to obtain.

Some situations simply require CSE or kindred functions such as SUMPRODUCT or FREQUENCY because the computations cannot be done with ordinary functions.

> is it just a preference and experience thing,

No, I hope not. The CSE and SUMPRODUCT formulas incur sizeable performance costs when applied to large sets of data. So, they should not be used lightly.

> or is there any black n white logic ?

This is a though question: I believe there are enough clear cut situations nothing else will do.

Bob Umlas and Mark W.,[*] I notice, are online. They may want to comment as well.

[*] in alphabetical order.

Aladin

========