software

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

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

Cheers,
LeoHi Leo

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

--
Regards

Roger Govierquot;Leo Kernerquot; gt; wrote in message
...
gt; how do you go about assignig the lesser of two values to a cell in an
gt; IF
gt; structure? Something like...
gt;
gt; IF (A34 gt; 23456, lesser of C21 and J4,...)
gt;
gt; Cheers,
gt; Leo
gt;
Leo

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

Regards

Trevorquot;Leo Kernerquot; gt; wrote in message
...
gt; how do you go about assignig the lesser of two values to a cell in an IF
gt; structure? Something like...
gt;
gt; IF (A34 gt; 23456, lesser of C21 and J4,...)
gt;
gt; Cheers,
gt; Leo
gt;
Use MIN(C21,J4)

Petethanks you all!

Leo Kerner wrote:

gt; how do you go about assignig the lesser of two values to a cell in an IF
gt; structure? Something like...
gt;
gt; IF (A34 gt; 23456, lesser of C21 and J4,...)
gt;
gt; Cheers,
gt; LeoThanks for the responses, but i am having troubles.
a cell reads
=IF(I21gt;99790,I4, IF(I21gt;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

Leo Kerner wrote:

gt; how do you go about assignig the lesser of two values to a cell in an IF
gt; structure? Something like...
gt;
gt; IF (A34 gt; 23456, lesser of C21 and J4,...)
gt;
gt; Cheers,
gt; Leo
a cell reads
=IF(I21gt;99790,I4, IF(I21gt;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

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?

PeteLeo

MIN((I21, 59790)

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

Regards

Trevorquot;Leo Kernerquot; gt; wrote in message
...
gt; Thanks for the responses, but i am having troubles.
gt; a cell reads
gt; =IF(I21gt;99790,I4, IF(I21gt;59790,MIN((I21-59790)*0.15, 0), 0))
gt; I21 is 61,820
gt; I expect the value to be I21-59790)*0.15
gt; but I get 0.
gt; Any help?
gt; Leo
gt;
gt; Leo Kerner wrote:
gt;
gt;gt; how do you go about assignig the lesser of two values to a cell in an IF
gt;gt; structure? Something like...
gt;gt;
gt;gt; IF (A34 gt; 23456, lesser of C21 and J4,...)
gt;gt;
gt;gt; Cheers,
gt;gt; Leo
gt;