Thanks everyone! Obviously I'm a bit of a "detail" nut! Happy Holidays!

"Dave Peterson" wrote:

I think it's a pet peeve of many developers that people write formulas like:
=if(a1=b1,c1," ")
or use the space bar to clear the contents of cells (instead of hitting the
delete key).

It can really screw up formulas that look like:

=if(a1="","one thing","another")

It would have to be rewritten as:
=if(trim(a1)="","one thing","another")

just to make sure.

====
ps. That leading + (in +c1) is another pet peeve <vbg. It isn't necessary.

Julie Quass wrote:

I've noticed in various postings that the quotes symbols are used (or
suggested to be used) without a space between them. What is the difference
between including or not including the space?

An example of it's use would be: IF (A1=B1,+C1,"")

Thanks!

--

Dave Peterson