Leo

=IF (A34 23456, MIN(C21, J4),...)

Regards

Trevor


"Leo Kerner" wrote in message
...
how do you go about assignig the lesser of two values to a cell in an IF
structure? Something like...

IF (A34 23456, lesser of C21 and J4,...)

Cheers,
Leo