specifying the lesser of two values

L

Leo Kerner

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
 
L

Leo Kerner

Thanks for the responses, but i am having troubles.
a cell reads
=IF(I21>99790,I4, IF(I21>59790,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
 
L

Leo Kerner

a cell reads
=IF(I21>99790,I4, IF(I21>59790,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
 
P

Pete_UK

You are asking the formula to give you the lesser value of
(61820-59790)*0.15 and zero - even though it is small, the first number
is a positive number, and so is bound to be greater than zero. What is
it that you want to happen?

Pete
 
T

Trevor Shuttleworth

Leo

MIN((I21, 59790)

=IF(I21>99790, I4, IF(I21>59790, MIN((I21, 59790)*0.15, 0), 0))

Regards

Trevor
 
Top