Problem in writing if condition in VBA

[annupojupradeep]

I have a problem while writing a if condition formula in excelVBA

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.

I have more than 10000 line items in my worksheet.

Could you please help

Thanks,
Pradeep

[dilipandey]

Hi Pradeep,

I am not clear with you query, can you upload an excel workbook along with your expected results.. thx


Regards,
DILIPandey
<click on below * if this helps>

[annupojupradeep]

Hi Dilip,

Thanks for your quick response...

Here is the attachment for your reference....


Could you please help me on this issue...

Thanks & Regards,
Pradeep

[dilipandey]

Are you treating numbers in column A as set (batch) e.g., A5 is one set, A7 is another set, A9:A10 is another set... etc ?


If not, then logic is simple... <151 = Non reconciling item and >151 = small variance for clearance


Regards,
DILIPandey
<click on below * if this helps>

[mike7952]

Maybe this

Please Login or Register  to view this content.

[annupojupradeep]

Hi Mike,

A Very Good Morning...

Thanks a lot Mike.... its working perfectly...


Thanks & regards,
Pradeep