vba help - if condition check two values between

[Mallesh23]

Hi Team,

Need your help to check Outstanding amount Column A,
should be between -250 or +250, and Column B value Sap Balance.
should be between -250 or +250

if condition met , update column C. shown in below Table.

Book10
	A	B	C	D
1	Outstanding Balance	SAP Balance	Remark	Criteria to Decide Coumn C as follows
2	-250	150	Condition met	O/s Balance and SAP Bal Amount should be between + or – 250
3	-251	200	Condition met
4	265	250	Condition not met
5	-365	-100	Condition not met
6	0	300	Condition not met
7	-250	250	Condition Met
8	100	-400	Condition not met
9		200	Condition not met
Sheet1

Thanks for your help in advance


Thanks
mg

 

[Fluff]

How about

=IF(AND(ABS(A2)<=250,ABS(B2)<=250),"Met","Not Met")

 

[Mallesh23]

Hi fluff,

Perfect! it worked, I have written below code as per your formula suggested.

how to use select case for below code.

Sub Check_Amount_Greater_()
   
    Dim i As Long
    For i = 2 To 9
   
    If Abs(Cells(i, 1).Value) <= 250 And Abs(Cells(i, 2).Value) <= 250 Then
       
        Cells(i, 3).Value = "Met"
    Else
   
        Cells(i, 3).Value = "Not Met"
    End If
       
    Next i

End Sub

Thanks
mg

 

[Fluff]

I wouldn't use select case for this, it's of no real benefit.

 

[Mallesh23]

Hi Fluff,

how to use below condition

• For all the rows where value in field “Outstanding balance” is between + or -250 and “Balance As Per SAP” is + or – 250 (except zero),

how to exclude 0 here, this one is tricky in my VBA Code.


Thanks
mg

 

[Fluff]

You will have to include a condition for >0

 

[Mallesh23]

Hi Fluff,

Great !!! it worked ! many many thanks for your help. ?



Thanks
mg

 

[Fluff]

You're welcome & thanks for the feedback.