Search worksheet and If a row has 3 cells = text plus cell/cell>10% formula then "Y"

[cancan64]

I am trying to come up with an if statement if any row in a table has 3 cells matching the 3 set text plus if a 4th cell divided by a 5th cell is greater than 10% then "Y" otherwise "N".
Below is the formula which works if looking at a single row but I want to know if I get a single "Y" in the attached spreadsheet

Sorry cant seem to attach the worksheet


'=IF(AND(K24&B24&D24=$A$26&"Current"&"State: Not",((G24/F24)>10%)),"Y","N")'

[kersplash]

To attach;

Go Advanced -> Manage Attachments -> Upload

[kersplash]

A quick cursory glance - I think you are trying to use the & as an AND within your statement. & concatenates the contents of cells together.

[cancan64]

I basically want to know if any row in the workbook contains x, y z and if cell BB/AA is more than 10% then "investigate otherwise all is good.
I can do it in 2 formulas as in cell CC=if((BB/AA)>10%)),"Y","N" and then have a lookup the worksheet matching X,Y,Z,CC but trying for a single formula first

[kersplash]

I don't understand what you mean by AA, BB and CC.

In your attachment maybe mock-up what you want to see as a result.

[sandy666]

try IF(SUMPRODUCT(conditions_here)=1,Yes,No)

=1 is not required, it's just for clarify

[cancan64]

Thanks Sandy, Sumproduct worked

=IF(SUMPRODUCT((B3:B24=B24)*(D3:D24=D24)*(K3:K24=A26)*((G3:G24/F3:F24)>10%))>=1,"Yes","")

[sandy666]

You are welcome

Read me Try to avoid joining to my Black List by doing this below If that takes care of your original question, & to say Thanks and for better Motivation, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. If you did it already - ignore it. Thank you.