"John" wrote...
....
My problem is comming up with a complex formulas, how to start the logic and
proper syntax. this is why I would like a book on Nested Formulas or
anything that would help.

Do the reverse of what Bob did. If you currently use several formulas
to produce one final result, try to combine the formulas in each of
the cells into a single formula in a single cell.

Also, if you don't need to do this, why worry about it?

How did you learn how to do it ?

I figure most people who use very long formulas learned by doing. For
programming generally, nothing beats experience. It really is nothing
more than combining several calculations which could be performed
using multiple formulas in multiple cells into a single formula in a
single cell. It's not necessary to do this, but it sometimes works
better to do so.

Putting it another way, there are no books or web sites that deal
specifically with creating long spreadsheet formulas. Newsgroups like
this and learning by doing are really your only alternatives.