Formula Help-Multiple IF AND OR Function

[ANALYSTBANK]

This may sound like very basic, but I'm unable to put the formula correctly,

Column I Column K

ROW 1 10.00 100

ROW 2 12.00 220

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl70, width: 64"] [/TD]
[TD="class: xl65, width: 64"]Column I[/TD]
[TD="class: xl66, width: 64"]ColumnK[/TD]
[/TR]
[TR]
[TD="class: xl72"]ROw1[/TD]
[TD="align: right"]10[/TD]
[TD="class: xl67, align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl71"]Row2[/TD]
[TD="class: xl68, align: right"]12[/TD]
[TD="class: xl69, align: right"]220[/TD]
[/TR]
</tbody>[/TABLE]

Observation: 1) I2 data value is >1.2 times of data value in I1,
2) K2 data value >2 times of data in K1

My current formula is –

=IF(AND((I2/I1)>=1.1,(K2/K1)>=2),ROUND((K2/K1),2)&" Focus","Ignore")

So, if Observation 1), and 2) both are true, formula returns ‘K2/K1 value’ with suffix ‘Focus’, else text ‘Ignore’

Now Query,
Apart from meeting above twin conditions, I need formula also to check, if I2 value is within +-10% of I1 value, AND K2 data value is still >2 compared to K1,

If so, formula should return, ‘K2/K1 value’. With suffix ‘Alert’, else text, ‘Ignore’

So,

IF I2/I1 > 1.1 AND K2/K1>2 Result should be = K2/K1 + ‘Focus’

OR

IF I2/I1 within +- 1.1 range, AND K2/K1>2 Result should be = K2/K1 + ‘Alert’

ELSE

‘Ignore’

How to put it in formula?

 

[Andrew Poulsom]

Try:

=IF(AND((I2/I1)>=1.1,(K2/K1)>=2),ROUND((K2/K1),2)&" Focus",IF(AND(ABS((I2/I1)-1)<=0.1,(K2/K1)>=2),ROUND((K2/K1),2)&" Alert","Ignore"))

 

[ANALYSTBANK]

Thank You, Sir.