Hi!

The concept is really open to interpretation!

In my opinion a "smart" formula is one that accounts for all the possible
things that might cause the formula to fail. Fail meaning, returning
incorrect results.

A very simple "dumb" formula is:

=VLOOKUP(A1,Sheet2!A1:B100,2,0)

I'll let you figure out why it's "dumb"!

Biff

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