I guess you could check if this formula would produce the same value as the
last formula, then show nothing

=if(previous cell = "","",if(formula=previous cell,"",formula))

--
Regards,
Tom Ogilvy

hhaddick wrote in message
...
I am sorry for the confusion, Tom. What I meant is I get a long string
of 100.00 across my spreadsheet when what I want is a string of blank
cells.

Is there a way to accomplish this?

Again, sorry for the confusion.

Bill Haddick



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/