As an alternative, if "the formula" is very long, you may try this:

<< your formula with X=Y replaced with (((X<Y)+your condition)=1)

Hope this helps / Lars-Åke


On Sat, 26 Dec 2009 14:17:51 -0500, "Rick Rothstein"
wrote:

You didn't give us a lot to work with, but I think you are looking for
something like this...

=IF(<<your condition,<<formula with x=y,<<formula with x<y)