if condition wih multiple rows value

**annupojupradeep** · 03-14-2013, 03:49 PM

I have a problem while writing a if condition formula in excel not in VBA

example

Situation 1 (range)
a b
1 180 Small variance
2 151 small variance
3 280 small variance
4

Situation 2 (range)
5 350 Non reconciled
6 210 non reconciled
7 160 non reconciled
8 145 non reconciled
9 450 non reconciled
10

here i have mentioned Aging in Column A and Status in Column B. Cell A4 is blanck cell and A10 is blank cell

Situation 1
I need if any cell contains >150 aging then is Small Variance

Situation 2
if any one of cell (from A5-A10) acontains <=150 then all cell would result Non reconciled, even though the rest of cell are >150 aging. In this situation A8 is 145 and rest of all cells are >150 aging.

Could you please help

Thanks,
Pradeep

**Pauleyb** · 03-14-2013, 05:07 PM

In B1
=if(max($A$1:$A$3)>150,"Small Variance","")
drag down to B3

In B5
=if(min($B$5:$B$9)<=150,"Non reconciled","")
drag down to B9

**annupojupradeep** · 03-16-2013, 09:17 AM

Hi Pauley,

Many many thanks for your help.....

Here i need one single formula for both the conditions because I have more than 10000 line items with aging bar. So Can you help me on this....

If it is possible can you help on this issue with VBA codes

Thanks & Regards,
Pradeep