On Fri, 14 Oct 2005 18:43:03 -0700, "dede"
wrote:

our professor is asking us the difference between a dumb formula and a smart
formula and give an example. Any ideas?

It really depends, as others have said, on your prof's definition of
dumb and smart.

I remember seeing an adult class of spreadsheet beginners, being shown
that the way to add the numbers in A1:A3 was to write A1+A2+A3, rather
than the rather obvious =SUM(A1:A3)

I suppose you could argue that the latter formula is smart since you
can add rows in between 1&3 without upsetting the accuracy of the
result.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________