copy a cell amt AFTER IF equation

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.

On Mon, 20 Mar 2006 11:19:29 -0800, PatC
<PatC@discussions.microsoft.com> 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,CellRef_WhenFalse)

Substitute your Cell addresses for CellRef_WhenTrue &
CellRef_WhenFalse

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________