Hi Leo

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

--
Regards

Roger Govier


"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