| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
specifying the lesser of two values
Use MIN(C21,J4)
Pete |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding zero values in charts | Charts and Charting in Excel | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Linear Mode
