ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Formula (https://www.excelbanter.com/excel-worksheet-functions/146403-conditional-formula.html)

[email protected]

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



All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com