calculate sum of three numbers where the answer should be zero

[ashu1990]

Hi guys,

I am stuck into a following thing i have 3 amount where i need to calculate the sum of three amount and the answer should be zero i tried using loop but no sucess any suggestion would be appreciated

Do
If lp = 0 Then
amt = net_receipt_amt - Net_Charges_amt - Net_Income_amt
ElseIf lp = 1 Then
amt = net_receipt_amt + Net_Charges_amt - Net_Income_amt
ElseIf lp = 2 Then
amt = net_receipt_amt + Net_Charges_amt + Net_Income_amt
ElseIf lp = 3 Then
amt = -net_receipt_amt + Net_Charges_amt + Net_Income_amt
ElseIf lp = 4 Then
amt = -net_receipt_amt + Net_Charges_amt + Net_Income_amt
ElseIf lp = 5 Then
amt = -net_receipt_amt - Net_Charges_amt + Net_Income_amt
ElseIf lp = 6 Then
amt = -net_receipt_amt + Net_Charges_amt - Net_Income_amt
End If
If amt = 0 Then Exit Do
lp = lp + 1
Loop

You are going to have to provide a more detailed description of what your setup is and what you are trying to do with it... what you have posted is not clear to me at all.

[princ_wns]

Can yu please explain more as it is not clear what to do. It would be better if you can provide somthing with sample data with workbook.



regards
Prince