specifying the lesser of two values

  • Thread starter Thread starter Leo Kerner
  • Start date Start date
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
 
Leo

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

Regards

Trevor
 
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
 
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
 
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
 
Leo

MIN((I21, 59790)

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

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent "If" formulas 2
IF 1
help: sorting rows by lesser value of two columns 1
Vlookup with value between 2 cells and return greater value. 6
Programming a column so the it displays the lesser of two values 2
Comparing cell values then labeling them based on comparision 1
Creating a named range gives an error only when the filename is lo 1
Can someone help me with this formula please???? 7

Back
Top