| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If to determine lessor of three values
I am trying to build an IF statement that will return the lessor of three
values and although I think this should be easy, it's not working. So my values a H42 = 500 G44 = 400 G45 = 425 Here's my statement that's not working... =IF(AND(H42<G44,H42<G45),IF(G44<G45,G44),H42) thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the values? | Excel Discussion (Misc queries) | |||
| How to determine the values? | Excel Worksheet Functions | |||
| How to determine the values from a list? | Excel Worksheet Functions | |||
| I need to determine how frequently two values appear together | Excel Discussion (Misc queries) | |||
| How to determine geometric mean of 152 values? | Excel Worksheet Functions | |||
![Jo-Anne[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
