| Home |
| Search |
| Today's Posts |
|
#8
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 |
| 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 | |||
Threaded Mode
