Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAX function with IF Statement
I am trying to get the MAX value form a list using an IF statement with
March 1st 2006 as the condition. Based on the following abbreviated table, I wrote the following formula: ={MAX(IF((A2:A7<C1),B2:B7,0)} Date Rate March 1, 2006 January 1, 2006 1.1511 January 31, 2006 1.1560 February 1, 2006 1.1573 February 28, 2006 1.1614 March 1, 2006 1.1593 March 31, 2006 1.1450 I want to be able to rewrite the condition to specify a date range such as greater than Jan 31st but less than March 1st. Any help would be appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAX function with IF Statement
Nest the if statements
=Max(if((A2:A7<C1),If((A2:A7C2),B2:B7,0),0)) Charles xl Geek dbuc283 wrote: I am trying to get the MAX value form a list using an IF statement with March 1st 2006 as the condition. Based on the following abbreviated table, I wrote the following formula: ={MAX(IF((A2:A7<C1),B2:B7,0)} Date Rate March 1, 2006 January 1, 2006 1.1511 January 31, 2006 1.1560 February 1, 2006 1.1573 February 28, 2006 1.1614 March 1, 2006 1.1593 March 31, 2006 1.1450 I want to be able to rewrite the condition to specify a date range such as greater than Jan 31st but less than March 1st. Any help would be appreciated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAX function with IF Statement
thanks for he help
Die_Another_Day wrote: Nest the if statements =Max(if((A2:A7<C1),If((A2:A7C2),B2:B7,0),0)) Charles xl Geek dbuc283 wrote: I am trying to get the MAX value form a list using an IF statement with March 1st 2006 as the condition. Based on the following abbreviated table, I wrote the following formula: ={MAX(IF((A2:A7<C1),B2:B7,0)} Date Rate March 1, 2006 January 1, 2006 1.1511 January 31, 2006 1.1560 February 1, 2006 1.1573 February 28, 2006 1.1614 March 1, 2006 1.1593 March 31, 2006 1.1450 I want to be able to rewrite the condition to specify a date range such as greater than Jan 31st but less than March 1st. Any help would be appreciated |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MAX function with IF Statement
=MAX(IF((A2:A7A3)*(A2:A7<C1),B2:B7))
array entered -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dbuc283" wrote in message oups.com... I am trying to get the MAX value form a list using an IF statement with March 1st 2006 as the condition. Based on the following abbreviated table, I wrote the following formula: ={MAX(IF((A2:A7<C1),B2:B7,0)} Date Rate March 1, 2006 January 1, 2006 1.1511 January 31, 2006 1.1560 February 1, 2006 1.1573 February 28, 2006 1.1614 March 1, 2006 1.1593 March 31, 2006 1.1450 I want to be able to rewrite the condition to specify a date range such as greater than Jan 31st but less than March 1st. Any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function or If statement help | Excel Worksheet Functions | |||
IF function returns function statement rather than result | Excel Worksheet Functions | |||
IF Then statement or another function to look for a value | Excel Worksheet Functions | |||
Function IF statement | Excel Worksheet Functions | |||
MID STATEMENT vs MID FUNCTION | Excel Programming |