Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formula
I'm having trouble updating a conditional array formula to fit new
criteria. Right now, I have something that looks something like this: {=IF(AND(($O6-$O$2:$O$7)<1),true,false)} Basically, if a number in the array is equal to or less than every other number in the array, it returns TRUE. (value) (result) 1 false 1 false 1 false 1 false 0 true 1 false Now, I want to limit the array it looks at, so it only considers values that are in the same row as the letter "l". I want the result to change to something like this: (value) (letter) (result) 1 l true 1 l true 1 l true 1 l true 0 s false 1 l true Because the 0 is no longer considered, each of the 1's are equal to each other. All numbers not considered would return false. Thank you for any help. -bgetson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formula | Excel Worksheet Functions | |||
conditional formula | Excel Worksheet Functions | |||
Conditional formula | Excel Worksheet Functions |