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

	Column I	ColumnK
ROw1	10	100
Row2	12	220

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

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.