| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If to determine lessor of three values
Jo-Anne wrote...
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 .... Why not use =MIN(H42,G44,G45) ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If to determine lessor of three values
use
=Min(H42,G44:G45) "Jo-Anne" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If to determine lessor of three values
If you really wanted to use an IF statement, then you could change your
formula to =IF(AND(H42<G44,H42<G45),H42,IF(G44<G45,G44,G45)) because the syntax of an IF statement is IF(condition,value if true,value if false), but of course MIN is the simpler way. -- David Biddulph "Jo-Anne" wrote in message ... 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 |
| Reply |
| 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)
Linear Mode
