On Mon, 20 Mar 2006 11:19:29 -0800, PatC
wrote:

How do I complete a less than greater than equation,when the answer is true,
but having it go to another cell and copying that cell amount to where the
formula is.

What do you want the formula to be when the answer is true?

Generally

=IF(Something<=SomethingElse,CellRef_WhenTrue,Cell Ref_WhenFalse)

Substitute your Cell addresses for CellRef_WhenTrue &
CellRef_WhenFalse

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________