Leo

MIN((I21, 59790)

=IF(I2199790, I4, IF(I2159790, MIN((I21, 59790)*0.15, 0), 0))

Regards

Trevor


"Leo Kerner" wrote in message
...
Thanks for the responses, but i am having troubles.
a cell reads
=IF(I2199790,I4, IF(I2159790,MIN((I21-59790)*0.15, 0), 0))
I21 is 61,820
I expect the value to be I21-59790)*0.15
but I get 0.
Any help?
Leo

Leo Kerner wrote:

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