specifying the lesser of two values
 

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

specifying the lesser of two values
 

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

specifying the lesser of two values
 

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

specifying the lesser of two values
 

Use MIN(C21,J4)

Pete

specifying the lesser of two values
 

thanks you all!

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

specifying the lesser of two values
 

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

Sintax problem?
 

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

specifying the lesser of two values
 

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

specifying the lesser of two values
 

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