When designing a spreadsheet it is good, first to sit down with paper and
pen and work out what is wanted in terms of input, 'manipulation' and
output. For the middle bit (manipulation) my approach is to write down a
table of all the possible cases (possibilities). A formula can then be
built up a case at a time (with, of course, what to do (e.g. "ERR") if none
of the cases are met. Having done this it is straight forward to build a
test spreadsheet with dummy data to test all the dummy data outputs are as
expected. Obviously this is an iterative process until it is absolutely
right. Even then it is right only insofar as is known at the time. Be
prepared for some new idea and to re-start the process.

It may be a bit tedious but an advantage is that it provides an opportunity
to test before the spreadsheet is released for use.

Regards.

Bill Ridgeway
Computer Solutions

"sandyramanuj" wrote in message
ups.com...
Often we use multiple formulaes in a work sheet, and to verify them at
a glance is not possible. I would request to group members, how to
review all the formulaes inserted in a particular work sheet all at
once, or is any way print out facility of the same is possible or not.
- Your valued answers will help others too for effecient checking all
the formulaes.
Regards Sandy