Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Leo Kerner
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth
 
Posts: n/a
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default specifying the lesser of two values

Use MIN(C21,J4)

Pete

  #5   Report Post  
Posted to microsoft.public.excel.misc
Leo Kerner
 
Posts: n/a
Default 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




  #6   Report Post  
Posted to microsoft.public.excel.misc
Leo Kerner
 
Posts: n/a
Default 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


  #7   Report Post  
Posted to microsoft.public.excel.misc
Leo Kerner
 
Posts: n/a
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default 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

  #9   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding zero values in charts fascal Charts and Charting in Excel 4 December 19th 05 03:17 PM
Keeping a cell value constant trhoughout a list of values borikua05 Excel Worksheet Functions 2 December 3rd 05 04:03 PM
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row Sam via OfficeKB.com Excel Worksheet Functions 6 November 29th 05 04:27 PM
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 03:41 PM
#N/A Values : Returned by Formulas vs Entered Manually monir Charts and Charting in Excel 8 July 7th 05 01:16 AM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"